cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimboSey
Helper V
Helper V

Calculate an average time taken to complete a project

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-JessicaG-msft
Community Support
Community Support

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:

 

vJessicaGmsft_0-1644389954802.png

vJessicaGmsft_1-1644390006793.png

vJessicaGmsft_2-1644390108465.png

 

 

Best Regards,

Jessica Gu

View solution in original post

1 REPLY 1
v-JessicaG-msft
Community Support
Community Support

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:

 

vJessicaGmsft_0-1644389954802.png

vJessicaGmsft_1-1644390006793.png

vJessicaGmsft_2-1644390108465.png

 

 

Best Regards,

Jessica Gu

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,541)