The some data is not getting visible in the looker studio chart

Looker Q&A Looker Studio
,
1

it is only showing the 7544 record instead of 8042
it is only showing the 7544 record instead of 80421919×913 83.3 KB

the actual record size

Some data is not visible in the looker studio chart, as the actual data has 8042 rows but it’s showing 7544 in google looker studio, which doesn’t make sense and hampering the report data.

2

Are all fields represented in the table? (Or at least all fields that would make a row unique.) The table will only display unique rows. Or are you aggregating metrics in the table? That would reduce the number of rows as well.

3

@1Aaryan
Just like Laura said you are probably not having an uniquer ID for each row which automatically aggregates data based on a metric you have selected for all non-unique dimensions.

Example

A Data Source with 3 rows:
Person - Date - Revenue

  1. Ana - 20201212 - 1200
  2. Ana -20201212 - 300
  3. Melisa- 20201210 - 1500

Will be displayed as two rows:

  1. Ana-20201212 -1500
  2. Melisa- 20201210 - 1500

When applying SUM function on revenue metrics and two other dimensions.

You can try to add metric as dimension instead and it will show you all data.

Arkady Zagdan
Bigglo.pl