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
Tera 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.

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