Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

help: "Sum" time aggregation missing from Formula Indicators using % Unit

vincentroge
Tera Contributor

When creating a formula indicator, I've taken to making the time series of contributing indicators as "daily" b/c I can change the time aggregation at the time of data visualization. (weekly, monthly, quarterly, etc)

But I noticed when I set the Unit of Measurement to Percent %, it restricts what Time Series Aggregations I can use, specifically doesn't let me SUM values. (example: "by month sum" vs "by month avg") 

I understand that ServiceNow states they don't include this because it's "not meaningful" but they clearly weren't thinking of Formula Indicators when they made this restriction. (referenced resource)

 

The way formula indicators work by default, they apply the time series aggregation before performing the 

vincentroge_0-1745964475860.png

 

 

when building the data visualization you'll notice that I can't select "by month SUM

vincentroge_1-1745964482879.png

 

Thank you in advance for any help you can give. 

1 REPLY 1

sizzleMcFace
Tera Guru

If you need the same time series for all Indicators included in the formula, selecting it in the visualization should have the same effect as specifying it for each Indicator in the formula.

 

So if they want to limit this because it is "not allowed" then it should be limited in both cases.

 

I understand the frustration though. As a workaround you can create another layer of formula indicators only used for applying the time series, and then use those in place of the automated indicators.