Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Time series aggregations in the Analytics Hub and widgets

Log in to subscribe to topics and get notified when content changes.

Time series aggregations in the Analytics Hub and widgets

A time series aggregation consists of an aggregation, such as AVG or SUM, combined with a time series, such as By quarter. The frequency with which scores are collected for the indicator determines which time series are applicable. Some time series include data from partial collection periods.

Time series and associated indicator frequencies

When you select a time series aggregation, the frequency with which indicator scores are collected limits which time series you can choose. You cannot select a time series aggregation that is applied to scores more frequently than those scores are collected. For example, the By week SUM time series aggregation can apply to an indicator with a daily frequency. However, By week SUM cannot apply to an indicator with a weekly, monthly, quarterly, or yearly frequency.

Note:
  • By Year and Year to Date time series are not available for daily scores.
  • Weekly indicators support only Weekly, 4w running, and 13w running time series. This limitation is because beginning and end dates of weeks do not necessarily coincide with the beginning and end dates of months, quarters, or years.
  • Bi-monthly and yearly indicators do not support any time series aggregations.

The following table shows which time series are supported for which indicator frequencies. These relationships are independent of which aggregation (AVG, SUM, or custom) is combined with a time series, and therefore only the time series are shown.

Time series Indicator frequencies
Daily Weekly Monthly Quarterly (Fiscal Q, 4-weekly, Bi-weekly)
Daily Yes No No No
7d running Yes No No No
28d running Yes No No No
30d running Yes No No No
4w running No Yes No No
13w running No Yes No No
3m running No No Yes No
6m running No No Yes No
12m running No No Yes No
4q running No No No Yes
By week, by week + Yes No No No
By month, by month + Yes No No No
By quarter, by fiscal quarter, by quarter +, by fiscal quarter + Yes No Yes No
By year, by fiscal year, by year +, by fiscal year + No No Yes Yes
Week to date Yes No No No
Month to date Yes No No No
Quarter to date, fiscal quarter to date Yes No Yes No
Year to date, fiscal year to date No No Yes Yes

Partial periods

Some time series include indicator scores from incomplete collection periods. These periods can include the current period and the period from the beginning of data collection. A plus sign in the name, +, identifies these time series.

A time series that does not include data from partial periods must have data from the beginning and the end of the period. For example, a By month SUM time series aggregation requires scores from the start and the end of the month to be present. Otherwise that month is not included. A time series that includes data from partial periods, such as By month SUM +, needs only data from one day in the period.

Warning: Partial periods can skew the results of certain aggregations, such as averages.

Default time series definitions

Performance Analytics comes with default SUM, AVG, and other time series definitions. Do not alter these definitions.

Warning: Any changes to time series definitions can have unexpected results.
Feedback