How can I get a single score report that captures average daily incidents opened on a month to date basis.

Monica Burgess · ‎07-02-2018

I am trying create a single score report that is on a dashboard that shows the average count. I am looking for an average of incidents opened daily on a MTD basis and then average incidents opened monthly for the previous three months. Once I choose average as the aggregation the aggregated field options do not let me choose to do an average count on opened. Any suggestions would be appreciated.

Adam Stout · ‎07-02-2018

You want an indicator with the number of incidents opened today (which is collected each day). This may exist OOTB. Once you have this, create a single score PA widget with a time series of AVG month to date + or by AVG By Month +. I would probably use a scorecard or breakdown scorecard widget instead of a single score with prior periods to show the last 3 previous periods.

View solution in original post

froehre31 · ‎08-04-2020

DJL- I submitted an idea: If you would like to add to it or give it a like that would be awesome!

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=a324c32bdb5ed450f21f5583ca96...