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.

Report
All responses (
Answers (