Way to Have Static Average Compared to Dynamic Aggregation

joebenz

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.

Sample Utilization.xlsx

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.

GrantSmith

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

GrantSmith

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

joebenz

Thank you, Grant! I will try this out!