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, 

            first you need to put 1 instead of 0 in that relative end field, because in Performance analytics you will get the data upto yesterday not on the current day

when you are selecting for last 1 month then you need to configure for the same

if you select last 30 days running sum, so for today it will consider 17 days for April and 13 days for May for calculating the score value.. so it doesn't make sense to display only one month name there.. it will always show the current date and will calculate the score from current date to last 30 days.. irrespective of the month

Regards,

Tushar

[Rohit8 · Accepted solution]

Right, I understand the limitation here. I found a workaround and created a manual indicator (monthly frequency) and populated the scores based on the original daily indicator source, using a scheduled job.

Thanks a lot for your help on this. 🙂

[Tushar Hirpurk1]

Ok thanks Rohit,

you can closed the thread so that in future anyone with same question it will easy to understand

Regards,

Tushar