--- 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 --- # Applying time series to result or to contributing indicators # Applying time series to result or to contributing indicators {#ariaid-title1} * Release version: Xanadu * * Updated August 1, 2024 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read For a formula indicator, a time series aggregation can apply either to each indicator in the formula individually or to the formula result. Decide how time series aggregation apply with the Apply time series to result option. You can select or disable this option in the Other properties tab of a formula indicator record. This option applies to any time series aggregation you apply to the indicator in Core UI [Performance Analytics widgets](https://servicenow-prod.fluidtopics.net/Da4VULgrw2D2GChwB8IMsg "Widgets enable you to define visualizations for indicator scores. Widgets are shown on dashboards.") and Analytics Hub, or in [Data visualizations in Platform Analytics](https://servicenow-prod.fluidtopics.net/cTK92MA3IiY1_3pv041ktA "Data Visualizations use graphics to show table, indicator, and other data. They combine and extend the functions of reports and Performance Analytics widgets from the Core UI."). This option also applies to the default time series if one is set on the indicator. Note: * The default time series applies only on the Analytics Hub and KPI Details. If you do not select a time series aggregation on a widget or data visualization, the default time series does not apply. * For the setting to take effect on the Analytics Hub or KPI Details, you must choose a real aggregate, if the indicator does not have a default time series set. If the time series is just the indicator frequency (daily, weekly, and so on), theApply time series to result setting does not apply. {#apply-time-series-result-components__ul_n1w_prr_nyb} When Apply time series to result is checked, first the formula is evaluated and then the selected time series is applied to the final result. When Apply time series to result is not checked, each [contributing indicator](https://servicenow-prod.fluidtopics.net/KzO1fGsm6GUEygdn1yjLBA#gloss-contributing-indicator "An indicator that is used in the formula of a formula indicator. A contributing indicator can be an automated or a formula indicator.") is evaluated and the default time series is applied to it. Then the formula is evaluated. The results between the two settings can differ significantly. Neither setting is wrong, but you have to think carefully about what you are measuring before making your choice. ## Applying a time series to result compared to applying it to contributing indicators Consider the formula indicator "% of new P1 incidents". Every day this indicator calculates the percentage of new incidents that are Priority 1 - Critical: ( \[\[Number of new incidents \> Priority = 1 - Critical\]\] / \[\[Number of new incidents\]\] ) \* 100 You decide that you want the result to display a 7-day running average by default on the Analytics Hub. In the Other tab of the indicator record, you select the 7d running AVG default time series. You apply the time series to the result. In the resulting calculation, the formula is resolved for each day. Then the average of the result is taken for that day and the previous six days: ((New P1/All new~Day 1~ \* 100) + (New P1/All new~Day 2~ \* 100)+ ... (New P1/All new~Day 7~ \*100)) / 7 You aren't sure if you want the 7-day average of the final result or the average 7-day average of each indicator. So, you copy the previous formula indicator, with the same time series, but with Apply time series to result unchecked. Now, the time series is applied to the `Number of new incidents > Priority = 1 - Critical` and `Number of new incidents` contributing indicators separately before the formula is resolved: (New P1~Day 1~ + New P1~Day 2~ + ... New P1~Day 7~) / (All new~Day 1~ + All new~Day 2~ + ... All new~Day 7~) \* 100 You plot both formula indicators in a time series widget to see the difference in outcome between the two settings. Because the default time series only applies on the Analytics Hub, you also add the 7d running AVG time series to the widget: **Related concepts** * [Prevent a contributing indicator in a formula from following breakdowns](https://servicenow-prod.fluidtopics.net/KftBL97ueZwJ2qomNKiwxA "You can select contributing indicators in a formula to not be broken down. When a user applies a breakdown to the formula indicator, the breakdown does not apply to these indicators.") * [Breakdown matrices in formula indicators](https://servicenow-prod.fluidtopics.net/arwRe8KHfg_nNnkcErCXrA "Formula indicators inherit breakdown matrices from indicators in the formula.") * [Indexing multiple indicators in a formula](https://servicenow-prod.fluidtopics.net/_~6pcilQgc15kzjsIklyQw "You can write a formula to measure what the gap is to the overall target of multiple, combined indicators. Such a formula indicator is called an 'index indicator'.") * [Changes to score_start/end because of different user time zones](https://servicenow-prod.fluidtopics.net/8qx69w7Vx1gQQvOa7_TIDw "For formula indicators, the values of the variables score_start and score_end are calculated based on the time zone of the user who is executing the formula. If users in different time zones execute the same formula, the values of score_start and score_end change.") * [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.") **Related tasks** * [Create a formula indicator](https://servicenow-prod.fluidtopics.net/pYgFpM6BB3XdUgPM_9DgPQ "Create a formula indicator to produce a new computed score from one or more other indicators. Besides indicator scores, the formula can include calculations such as the gap between an indicator score and the indicator target.") * [Get analytics methods in formulas](https://servicenow-prod.fluidtopics.net/cnVqjX~HC_wNUdbpJEVaJQ "To insert a calculated value from the Analytics Hub into a formula, use a method in the formula.") * [Detect indicators with no scores in a formula](https://servicenow-prod.fluidtopics.net/fTqPC09KyYCVj_CvqcZxDg "As the formula creator, you can handle contributing indicators that have null scores. First set the formula indicator to calculate the formula even when it contains a null score.")