Show Last 30 days running sum as Monthly score

[Rohit8]

Hello,

Based on the sys_ui_navigator_history table, We have an indicator that shows the dashboard view count for a particular dashboard. The indicator source is set to Daily frequency and the Indicator Aggregate is set to Count Distinct (on 'created by' field) to reflect the number of individual viewers for the day. We have been using the Month Sum+ Time series to show the view count per month.

This indicator is part of a bigger formula indicator comprising of different other monthly metrics and altogether they roll up to a combined monthly score.

Now, we've been requested to show the view count based on Last 30 days rolling sum. At first, it seemed easy but then I found that once I change the time series to Last 30 days Running sum, the score date also changes to a date instead of the current month. And just because of this one indicator, the same thing happens to the combined score on the dashboard, the date on it changes to May 12 instead of May.

I tried with a new indicator source with frequency set to monthly with additional condition - Created in last 30 days, but then the Count Distinct breaks, it shows individual viewers for that entire month instead.

I understand that the indicators are working as per their expected functionality but can anyone suggest a workaround or solution for this request. I tried a formula indicator based on the original automated indicator but that also shows a date instead of month.

Any help would be appreciated.

Thank you.

[Tushar Hirpurk1]

Hi Rohit,

            Have you try to collect the data for particular indicator for the last 1 month,

like in data collection jobs when you are collecting a data for that particular indicator lets make relative start as 1 month ago it will collect the data for last 1 month.

Please mark reply as Correct/Helpful, if applicable. Thanks!

Regards,

Tushar

[Rohit8]

Thanks Tushar, It still doesn't affect the dates appearing on the score.

[Tushar Hirpurk1]

Have you Run the jobs? like on demand or set like monthly, weekly

can you just post what steps you followed?

Regards,

Tushar

[Rohit8]

Yes, this is the indicator source:

The Temporary On-Demand Job:

The score then incorrectly shows 4 (Count distinct of all Individual Viewers for the Month)

Once I change the Indicator source to Daily frequency and run the job again.

This is the score I get, which is correct but we need it to be shown as a monthly score (for May), but if we change the time series on that score widget to Month SUM+ it shows 81. That's the issue, I am not sure how to show this score as a score for the Month.

Thank you.