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