---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Select time aggregation in KPI Details

# Select time aggregation in KPI Details {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 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](https://servicenow-prod.fluidtopics.net/k_Ohw_RPzVEMYuISHfc1UA#applying-time-series-aggregations "You can aggregate changes in indicators into discrete time intervals. These aggregations can make trends more easily visible, or help track progress against a target."). 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](https://youtu.be/aM6JtUndRYk).

## Procedure

1. In KPI Details, expand the time aggregation menu on the indicator visualization.  
   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](https://servicenow-prod.fluidtopics.net/iD4N5Aii39KZ3E59dnXX6g "Some time series aggregations are inappropriate to apply to some indicators. You can exclude time series on automated, formula, and manual indicators. Excluded time series are not selectable from the Analytics Hub, KPI Details, or widgets. Other time series remain selectable.").
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 {#select-time-series-aggregation__example_tqm_wyh_n4b}

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.

**Related concepts**   

* [View contributing indicators to a formula in KPI Details](https://servicenow-prod.fluidtopics.net/xTDrw_Omqu_STbJ2zUofHQ "If you’re viewing a formula indicator in KPI Details, you can list the contributing indicators to that formula. Depending on the KPI Details configuration, you can open the contributing indicators in KPI Details.")
* [Show, compare, and edit records in KPI Details](https://servicenow-prod.fluidtopics.net/rDkWdd_yj6mty48Dbd31bw#show-compare-edit-records "You can view the list of records underlying an indicator score. You can edit individual records or compare records.")  
**Related tasks**   

* [Filter KPI Details by breakdown elements](https://servicenow-prod.fluidtopics.net/L63Ek_h72TIyKPv8Re~j_A#apply-brkdowns-element-kpi-details "In KPI Details, you apply breakdowns and elements to the indicator in the Filters sidebar.")  
**Related reference**   

* [Chart options in KPI Details](https://servicenow-prod.fluidtopics.net/b4Yj~mIEjvTwIbZzBXDEkw "The KPI Details Chart options menu enables you to show, hide, or change aspects of an indicator visualization. Selected chart options persist per user for each indicator. Chart options are divided into analysis, time series, and chart type options.")