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. 

[Bhuvan]

@AmberTemple 

If you are looking for a report, this is much easier to configure. You can configure function field to calculate the percentage utilization and schedule it to be a daily or monthly report based on your requirement.

If you are looking to setup PA dashboard, you can use below high-level steps as reference

1. Create a indicator source

2. Create indicator to collect the reservations and capacity. Use aggregate as 'Maximum' for reservations

3. Define a data collection job to run daily

4. Check if you want to create any breakdowns for example, building by location, by room type [for example Suite, VIP] that would add value and breakdown matrix to be mapped

5. Create a formula indicator to calculate the utilization 

If this helped to answer your query, please accept the solution and close the thread.

Thanks,

Bhuvan

[Bhuvan]

@AmberTemple 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[AmberTemple]

Thank you for your response. Unfortunately setting the reservation indicator to a "maximum" aggregate would not work because there is no field on the reservation table that has a count of the number of reservations per space, which is what I'm trying to measure. Each reservation record represents a single reservation for a space. What I'm looking for is either to do a scripted automated indicator to calculate the utilization, or do a formula indicator but somehow set the formula to show only max/peak scores.