Add calculated field (AVG, MIN, MAX) not impacted by filter view/quick filter

Looker Q&A Looker Studio
,
1

Hi everyone,

I am currently working on a dashboard to analyze our main competitiors across key KPIs like sales, gross profit, operating profit, etc.

I have now several line charts to show each KPIs, see example. I have two filters on this page, one to select the company I want to look at, and the time periods I want to show.

Joggele89_0-1741353584487.png
Joggele89_0-1741353584487.png639×317 13.3 KB

What I want to do now is to add a calculated field like the average, minimum or maximum gross profit across all companies in the same chart. Is there a way to do this? I tried to add calculated field for AVG and it is obviously only calculating the AVG across the company selected in the filter, but not across all companies in the dataset.

Would appreciate any help! Was not able to track down the right solution thus far.

2

Right, so when you apply a filter to a chart, the filter will apply to all fields in the chart. So I think that won’t work for your use case.

Instead, what about using a parameter? The parameter doesn’t immediately affect a chart, but you can reference the parameter in your calculated field to make a a “filtered” version of the field, while the default version of the field will show all values.