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.

[acrascall]

Hi Tracy,

I used a formula like this, essentially the addition of a "by month sum" in the formula.

( [[Number of open incidents / By month SUM +]] - [[Number of open incidents not updated in last 30 days / By month SUM +]] ) / ( [[Number of open incidents / By month SUM +]] ) * 100

thanks,

Andrew