Select time aggregation in KPI Details

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read

    • You can aggregate changes in indicators into discrete time intervals. A time aggregation consists of an AVG or SUM function combined with a time series, such as By quarter.

    Before you begin

    Role required: None. However, upgraded instances may require pa_viewer.

    About this task

    To explore a different time aspect of the indicator, apply one of the following time aggregations:

    Running
    Smooth out spikes to reveal trends. For example, looking at daily incident counts may show a decrease every weekend, but a 7-day running average smooths out those drops.
    Period
    Aggregate data to a less frequent period. For example, you may want to track the number of P1 incidents daily, but the frequency is too high when scores are considered daily. Instead, you can set a target at the monthly level with a "By Month” time series.
    To date
    Show cumulative scores. These time aggregations are useful when you have a monthly target to hit, but you also need to see the velocity throughout the month.

    For more information about the use, behavior, and limitations of time aggregations, see Applying time series aggregations. For examples and a deeper exploration of using time series aggregations with indicators, see this Performance Analytics Academy video, Leveraging Time Series with Performance Analytics.

    Procedure

    1. In KPI Details, expand the time aggregation menu on the indicator visualization.
      The control for expanding the time aggregation menu
      Note:
      Time aggregations are not available for real-time scores. When you select a time aggregation, real-time scores are disabled. If you return to the default frequency, real-time scores are re-enabled but turned off. You can turn them on if you want.
    2. Select either a Running, a Period, or a To date aggregation to configure.
    3. Select a time period.
      Invalid and excluded time periods for the indicator frequency are not enabled. For more information about excluded time periods, see Exclude time series from an indicator.
    4. Select either the average or the sum function.
    5. If you have selected a Period aggregation, decide whether to Include partial periods.
      If you include partial periods, you show a score for the current period even when it has not yet completed. Use caution because including partial periods can skew averages.

    Result

    The indicator visualization refreshes with each selection you make. Change your selection as much as you want. To return to the default time aggregation for the indicator, select Reset.

    Time aggregation on an daily indicator

    In the following time aggregation menu, the daily indicator Number of open incidents is aggregated by period to a weekly sum. Partial weeks are not included.

    Time aggregation menu for a daily indicator, showing a Period aggregation to a weekly sum