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. 

0 REPLIES 0