Performance Analytics Time Series

[John VanBruggen]

I have a question is regards to Time Series functionality within ServiceNow's Performance Analytics.   I am wanting to create a couple of different dashboard components that show various percentages.

%Month to Date

%Monthly

The issue is that I am having a hard time figuring out how to do percentages in a Time Series.   For a widget that is using an indicator that has a unit of % Time Series will not work.   So I have tried to edit the formula to use the Time Series info.

I am not actually doing this in incident, but this is an example of something that I have tried.

([[Number of new incidents / Priority / 1 - Critical / Week to date SUM]]   / [[Number of new incidents / Week to date SUM]]   ) * 100

Unfortunately it doesn't seem to do what I want it to do.   I don't really see any difference in results from that and without the 'Week to date SUM' portion.

I have also tried to edit the Indicator itself by editing the Default time series on the Other tab.   That doesn't seem to do anything at all.   What is that for?

Anyways, any help I can get with this would be totally awesome.   Thanks in advance.

[pieter_goris]

Hi John,

I've tested two formula indicators on a Fuji patch 5 instance, one with the Week to Date time series and one without. It generates different results for me:

and drilling down to 1 indicator:

For the last two dates in this chart a Monday and Tuesday there are no new critical incidents and hence the the Week to date SUM score is 0.

Maybe you are just unlucky with the indicators you picked in your test in that there is no difference between the Daily score and the Week to date score as in the screenshot above for the last two dates.

===============

The default time series on the other tab will change the time series as displayed on a (detailed) scorecard from the indicator's collection frequency (usually daily) to the one you selected.

and

But it is just being a default, you can select a different time series in the detailed scorecard

Cheers, Pieter

[John VanBruggen]

Thanks Pieter,

I was able to get to that point as well without any issues.   My problem began when I wanted to use a timeline with an Indicator that has a Unit of measure = %.   An OOB example would be % of new critical incidents (Which uses the example you gave above as part of its equation).   I haven't figured out yet how to use this type of an indicator in a Time Series.   It won't let me do it on the dashboard as it errors.(unless I use AVG).

I guess that in the end, I would like to accomplish something similar to the following:

On a dashboard, display a widget that gives a percentage based on the following:

( Month to date sum of New Priority 1 incidents / Month to date sum of New incidents ) * 100)

So, if I had 10 Priority 1 incidents out of a 100 incidents on Day 1, the percentage on day 1 would be 10%.

On Day 2, there were 10 more Priority 1 incidents of 100 incidents.

The Month to Date SUMs would now be:

20 priority 1 incidents and

200 incidents.  

Day 2 percentage would not change.   It would stay at 10%.

Day 3 was a holiday and there were no incidents.

The Month to Date SUMs would not change and thus the Percentage for Day 3 would stay that same as well.

Hopefully that clears up what I am trying to accomplish here.

--John VB

[acrascall]

Hi John,

Was there any answer to this question ? pieter.goris

I am also trying to accomplish a similar outcome and show a month sum based on a formula % indicator on the dashboard.   The only options I have are for AVG or AVG + which gives a view but not the view I am trying to achieve. i.e. There is a 2% deviation comparing the average and the actual sum.

regards,

Andrew

[tracydavis]

I'm having this same issue and we are in Helsinki. Anyone ever figure out how to get the % to display correctly? It's an easy enough formula, I don't know why it doesn't calculate correctly.