Calculate an average time taken to complete a project

[JimboSey]

Hello, 

I have an Workplan App to keep track of all my teams projects. On the main screen I have a gallery which lists all the current projects from my SharePoint list.

Within the gallery I have a label for project start date and a label for the project end date (which link to the start/end dates in the SP list, they are date/time columns).

Each project has a catagory, for this lets say we have the following catagories 'Catagory1', 'Catagory2' and Catagory3' in reality there will be more than this.

Id like to have another screen, where I want to have a gallery that filters by catagory from the main gallery on the main screen. I want the gallery to filter by catagory, I then want to work out from the start/finish date for each project within that catagory what the average number of days it has taken to complete the projects within that catagory.

Any help greatly appretiated. 

[v-JessicaG-msft · Accepted solution]

Hi @JimboSey ,

You could create a "vardata" collection in Gallery1 to save records for items of the same type, and another "t1" collection to save the completion days for each project. Set  Gallery2 data source to the "vardata" collection, and use the "Average" function to calculate the average of the "t1" collection. I have a test for you reference, please refer to this workaround:

Best Regards,

Jessica Gu