You’re offline. This is a read only version of the page.
Announcements
321
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.
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
Share
Report
All responses (
Answers (
