Help! Creating Monthly Count of ua_app_usage Table in Performance Analytics

SN241
Tera Contributor

Can someone help me create a monthly count of the ua_app_usage table using Performance Analytics?

I have already created this in Reports, but I need it to be done in Performance Analytics to also display months with 0 (zero) records.

SN241_1-1722848375984.png

 

Below is the monthly count per Accrual Period.

SN241_0-1722848332367.png

 

I would appreciate any help or suggestions. Thank you!

2 REPLIES 2

Mark Manders
Mega Patron

It's the same as creating it for tickets: do you already have the indicators and the job(s)? Once you are collecting the data, you can put filters and breakdowns on them.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Hi @Mark Manders 

Yes, I do have the indicators and jobs set up.

In Analytics, I have these scores, but they do not match the list table.

SN241_1-1722923259567.png

 

Below are the months with data; the other months should display as 0.

SN241_0-1722923189404.png


There is a mismatch in the results, as you can see below.

 

SN241_0-1722915903947.png