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

[Monica Burgess]

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]

I'm not sure if you can get this in a single score report.  I think you need Performance Analytics.

[Monica Burgess]

We actually do have Performance Analytics. How would I create just a single score that captures average counts using PA?

[Adam Stout · Accepted solution]

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.

[Monica Burgess]

Thank you so much, that worked perfectly.