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

Time series aggregations in scorecards and widgets

Time series aggregations in scorecards 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 or weekly frequency. However, By week SUM cannot apply to an indicator with a monthly, quarterly, or yearly frequency.

The following table shows what period between score collection (the indicator frequency) is the longest allowed for a time series. The longest allowed frequency applies to a time series with any aggregation (AVG, SUM, or custom), and therefore only the time series are shown.

Time series Includes partial periods? Longest indicator frequency
Daily No Daily
28d running No Daily
30d running No Daily
7d running No Daily
Fiscal quarter to date No Monthly
Fiscal year to date No Quarterly
Month to date No Weekly
Quarter to date No Monthly
Week to date No Daily
Year to date No Quarterly
12m running No Monthly
3m running No Monthly
6m running No Monthly
By month No Monthly
By month + Yes Monthly
4q running No Quarterly
By fiscal quarter No Quarterly
By fiscal quarter + Yes Quarterly
By quarter No Quarterly
By quarter + Yes Quarterly
13w running No Weekly
4w running No Weekly
By week No Weekly
By week + Yes Weekly
By fiscal year No Yearly
By fiscal year + Yes Yearly
By year No Yearly
By year + Yes Yearly

Yearly aggregations

By Year and Year to Date aggregations are not available for indicators with daily score collection due to performance reasons.

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 aggregation 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.