79231620

Date: 2024-11-27 19:22:53
Score: 2
Natty:
Report link

My workaround was to go to Resource > Manage added data sources > Edit

I added a new dimension called 'Exclusions'

I used a Case statement in this to set the field value to 'Exclude' for items I wished to exclude, and 'Include' for items I wanted to include.

I then set the Exclusions field in the drop down list, and set the default value to 'Include'

Instructions for the case statement: https://support.google.com/looker-studio/answer/7020724?hl=en#zippy=%2Cin-this-article

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Stuart Clark