Way to Have Static Average Compared to Dynamic Aggregation

I am looking to show the Utilization rate for customers over a period of time. I have a dataset that has all customer utilization data and want to be able to show how that stacks up to the whole company average for that period. My goal is to have the utilization value be the aggregated utilization value that can be filtered based on the company. And I want the Comparison Value to be the entire average of all companies without being filtered when a filter is applied. Attached is an example of the chart construction, as well as sample data to paint a picture.
Is there a way to achieve this? I've looked into Segments, but that seems there needs to be the existing data in the dataset to segment.
Best Answer
-
Look into using FIXED functions in a beast mode with the FILTER NONE option to prevent filtering from being applied
https://domo-support.domo.com/s/article/4408174643607?language=en_US
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Look into using FIXED functions in a beast mode with the FILTER NONE option to prevent filtering from being applied
https://domo-support.domo.com/s/article/4408174643607?language=en_US
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thank you, Grant! I will try this out!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive