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. 

[Bhimashankar H]

Hi @AmberTemple ,

For this you have to use the performance analytics for sure.  Whenever there is requirement to show the data in percentage format then you need to create indicators like indicator source, automated indicators, data job.

• Create a Performance Analytics Indicator for utilization % (reservations / capacity).

• Create daily data job collector. 

• Use Breakdowns by building (PA dimension) so you can track scores per building.

I believe this is best solution you can design for such reports.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[AmberTemple]

Hi @Bhimashankar H, thank you for your response.

Yes, I understand it will need to be done through Performance Analytics (maybe I posted this in the wrong forum but I wasn't aware of one for Performance Analytics). 

My question was more on how to display the max score for each month (so one score for May, then April, June, etc.) for a formula indicator. I know we can set the aggregate of an automated indicator to Maximum but I wasn't aware of a way to do this for formula indicators. That's why I thought about maybe doing an automated indicator that uses a script to calculate the percentages. 

Hopefully that cleared up my question a little bit more! 

[TheJoeDC]

You may need a couple of indicators here:

1) Manual/Automated - conference room capacity (breakdown by room)

2) Automated - conference room bookings (breakdown by room and date), use maximum as the aggregation

3) Formula - % utilization by using 1 and 2

Something like this may work

[AmberTemple]

@TheJoeDC Thanks for your suggestion. Unfortunately I don't think this works for the same reason as @Bhuvan  's suggestion.