You can aggregate changes in indicators into discrete time intervals. A time series
aggregation consists of an aggregation, such as AVG or SUM, combined with a time series, such as
By quarter. These aggregations can make trends more easily visible, or help track progress against
a target. You set up these aggregations either in the Analytics Hub or on Performance Analytics widgets.
While daily indicator scores are foundational and almost always desired, sometimes you also
want to have the scores available by week, month, or quarter. In other cases, you want to have a
month/quarter/year-to-date number that shows cumulative progress up until the current point.
Instead of defining multiple indicator sources and indicators to track each interval, Performance Analytics natively allows you to
capture the data once and then adjust the view. Use a time series aggregation for any of these
- Aggregate the data to a less frequent period
- Smooth the data with a rolling average
- Determine a period-to-date score
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
Default aggregation definitions
Performance Analytics comes with default
SUM, AVG, and other time series aggregation definitions. Do not alter these definitions.
Warning: Any changes to aggregation definitions can have unexpected results.
Excluding time series aggregations for an indicator
Some time series aggregations, while technically allowed, are not helpful to apply to an
indicator. For example, a SUM of percentage values is unlikely to provide useful insight.
Exclude these time series aggregations manually from the indicator. For more information, see
Exclude time series from an indicator.