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.