I am stuck on why I'm getting 2 different numbers in Looker for GA with calculated field and filters.
it's only a 190 delta but I don't even know how to answer clients question about why it's being calculated differently, other than one is a filter and the other a calculated field.
Here's my setup, I have a scorecard using 2 filters, one for organic, one for LPs that start with /news.
Then in a table I created a calculated field to group the URLs with CASE SQL
Both using same date range, dimensions and metrics.
What do I NOT know about calculated fields and casing vs filter?? SQL is overreporting a bit. Is the higher number more accurate?