help: "Sum" time aggregation missing from Formula Indicators using % Unit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2025 01:05 PM - edited 04-30-2025 07:33 AM
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
when building the data visualization you'll notice that I can't select "by month SUM"
Thank you in advance for any help you can give.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2025 11:09 PM
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.
