How do you create a new Time Series Definition in ServiceNow.

[jduval]

I can edit the Time Series Definitions but there is no option to create New in Istanbul.

Or if there is another solution for the following: I need a 'Distinct Count' of Open Incidents by week.

Since Data is collected Daily, the 'SUM by Week' won't work as it sums up each day's open incidents. I can't use the AVG by Week either, as we need the distinct Incidents open that week.

[Sri61]

Hello John,

            From the link, Performance Analytics - ServiceNow Wiki these are a set of predefined time periods and creation option is not present by default.

• Time Series Definitions: View and edit predefined time periods for gathering a meaningful collection of data, such as a 7-day running sum or average, or a total sum of previous weeks.

There is an enhancement request already in place though.

Hope this information helps. Thank you

Best Regards,

Sri

[Dan_Kane]

You could create a weekly indicator source and indicator that collects every day. As each day's collection runs, the indicator score for the week would be updated (overwritten) by the value from the current collection. Doing it this way would also give you the ability to report on the current week in progress.

Indicator Source:

Indicator:

[jduval]

Thanks Dan,

I hadn't thought of that. That's a Really good option. We have a similar issue with Problems with Related Number of Incidents on a Monthly basis. So we could have a Monthly indicator that collects daily and overwrites. That would be perfect.

Thanks,

John

[Dan_Kane]

So we could have a Monthly indicator that collects daily and overwrites. That would be perfect.

Yep, exactly. That's the way I always had to do aggregates for a month or week in progress, before the SUM+/AVG+ options came along. Glad it helps!