Looker Studio: Scorecard and Table to not mach! Are you guys facing the same issue?

[paulgerlee]

Hey guys,

recently, I'm getting more and more questions from customers why the same data in Looker Studio does not match when using a scorecard and a table!

The issue in detail: I created a simple report in Looker Studio showing GoogleAnalytics4 (GA4) sessions over time (current month). I added a scorecard, table, and bar chart to the report page. The bar chart data is wrong and underreports compared to the scorecard, the data table, and Google Analytics 4 itself.

Debugging:

• There are no report filters in place, no custom data, no formulas, no blends, nothing. Just a simple date range and reference to actual sessions. I'm connecting directly to GA4. 

• I tried setting the bar chart to display as daily, weekly, monthly, etc and it always comes up short.

• When I change the bar chart 'chart type' from bar chart, to scorecard, the correct number displays, and when I change back to a 'bar chart' it goes back to the wrong number.

• I see the same issue in other reports I've created for other websites in separate dashboards with entirely separate data sources.

I also see a similar issue between scorecard/chart data discrepancies when creating a calculated field to measure conversions by total users. In that case, the bar chart overreports vs the scorecard.
Is this common? A bug? Any way to resolve it?

[lauratilton]

Sounds like it may be an aggregation issue. What is the aggregation on your metric on the scorecard? On the bar chart?

Can you send a screen shot of the Setup side panel for each of these (showing dimensions, metrics, and sorting)? That may help us help you.