Hi everyone,
I need help with Looker Studio to display metrics with different filters in the same table.
Context: I’m tracking applications on a franchise website. I have a table with:
-
Dimension: Page path (e.g., /franchise/buffalo-grill)
-
Data source: Google Analytics 4
What I want:
| Page path | Total Sessions | Applications |
|---|---|---|
| /franchise/anacours | 10 | 4 |
| /franchise/yatta-ramen | 15 | 3 |
-
“Total Sessions” column = ALL sessions on the page (no filter)
-
“Applications” column = ONLY sessions with the event
form_submission_candidat...OR hostnamecandidater.lexpress-franch...
My problem: When I apply a filter at the chart level, BOTH columns get filtered. I can’t figure out how to have:
-
One unfiltered metric (total sessions)
-
One filtered metric (applications only)
in the same table.
What I’ve tried:
-
Chart-level filters → filters both columns
-
Metric-level filters → can’t find this option in Looker Studio
-
Calculated fields with CASE WHEN → not sure about the right formula
My question: How can I display an unfiltered “Sessions” metric AND a filtered “Applications” metric (based on a specific event) in the same table?
Should I use a calculated field? If yes, what would be the correct formula with GA4?
Thanks in advance for your help! 
