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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive