Performance Analytics - How the "Apply timeseries to result" field value affects the result of a formulaIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } PA - How the 'Apply timeseries to result' field value affects the result of a formula Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All Releases Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Procedure Automated Indicator 1 : Indicator 1 – New : Number of New incidents Automated Indicator 2 : Indicator 2 – Open : Number of Open incidents Formula Indicator : demo formula Calculation : [[Indicator 1 - New]] / [[Indicator 2 - Open]] These are new indicators and we collected scores only for January 2017. Keep in mind that "Formula indicators round fractional results using Banker's rounding or mathematical rounding depending on the indicator Precision." Precision Timeseries Indicator 1 – New : Number of New incidents 2 -None- Indicator 2 – Open : Number of Open incidents 2 -None- demo formula : [[Indicator 1 - New]] / [[Indicator 2 - Open]] 5 -None- Widget By Month AVG + Apply timeseries to result is a field on the Formula indicator. Apply timeseries to result value If "Apply timeseries to result" is true we calculate the Average on the result of the Formula which is "Column C". If "Apply timeseries to result" is false we calculate the Average per Column (an AVG on "Column A" then on "Column B") and we apply the formula calculation on the calculated average values (54,86 / 245,71 = 0,22326). In the scenario below, both the Numerator and Denominator have 0 scores recorded for some days. This affects the formula's result when 'Apply timeseries to result' is set to TRUE, as it excludes the days with no scores from the final calculation while performing the AVERAGE [By Month AVG or By Month AVG+] Note: For automated indicators, if Value When Nil = 0 is set, the indicator-level score is populated as 0. However, breakdown/element-level entries do not get individual 0 values. Instead, they inherit the parent-level score (i.e., for the day) as 0, which is logically applied in calculations. If 0 entries were created for every element, it would result in unnecessary high data volume in the table without adding relevant value.