Average Incident per Month as single number

OliverB · ‎03-11-2024

Is there a way that I can get an average number of incidents per month for the last year as a single number readout? I have not been able to use the average aggregation to return the correct number.

Thanks Oliver

AndersBGS · ‎03-13-2024

Hi @OliverB ,

Ok, got it - no you can't do that. average aggregation is only based on that the field is a number so you can do a sum and then an aggregation. For a count you can't do aggregation through the report builder, hence performance analytics is needed.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

Harmeet2Singh · ‎09-10-2024

Trying to find out even in PA how to achieve it, clueless. All I have achieved is getting average number of incidents for a month, not per month for current year.

Stephan11 · ‎10-21-2024

Hi can you please elaborate how PA helps in calculation the average I am looking for average incident per months. PA comes with OOTB reports none on average incidents.

S

OliverB · ‎03-12-2024

I can get a lot of average scores but I cannot seem to find an option to retrieve the average volume of tickets over a set time duration.