Peak/ Maximum Score Report

[AmberTemple]

Hello! I have a client that wants to see a line graph Data Visualization for WSD that shows the maximum utilization % (total reservations / total capacity) of building reservations for each month. The challenge I think is that every building has a different number of spaces, so it's not always true that the highest number of reservations is equal to the highest % of utilization.
 
The report should only show the peak score for that month, not an aggregate of all scores. They also want to do the same report but for weekly and daily peaks as well. What would be the the most efficient and accurate way to create this report? I thought about creating an automated indicator with a monthly frequency and creating a PA script to get the % utilization for all buildings but I was wondering if there are any better solutions. 

[Mark Manders]

You can't run it monthly, because that won't show the peak. That would just show you the monthly utilization. It does depend on how they want to view this. Do you need a breakdown per building, or is it really an over-all view of the total utilization? 

And I'm not sure if I get your statement about the challenge: if you have 1000 desks over 5 buildings, it doesn't matter if one building is on a 100% utilization and the others at 0%. The total will still be 20%. Unless it's per building, but then there also isn't a challenge. 

What you could do is collect the complete data with breakdowns per building, or collect it per building and use formula indicators to show the total (that would help with the challenge, since you are adding the building utilization to get an average).