Hi everyone,
I have an issue where the data in my Looker Studio tables are not summed correctly, whereas the tables' summary line is equal to the Google Query explorer's results
My table looks like this:
| Page Name (Custom field) | Average session duration | Engagement Rate | Active Users | Sessions |
| "Specific Page" | 2530.95 | 45.27% | 233 | 296 |
| null | 6.59 | 0% | 7 | 7 |
| Total | 164.02 | 59.56% | 163 | 225 |
The page name field is based on the following regex: REGEXP_EXTRACT(Page path without query string,'.*/([^/]+).html')
The filter on the query and on the chart is exclude screen resolution = 8192x4096 and include page path contains "specific page" so this is not a querying issue (The Google Query Explorers result are 164.01995503555557, 0.5955555555, 163, 225)
This is an extreme illogical example, but often I will get a reasonable table that still will not add up correctly/precisely.
Does anyone know technically why this happens?
Cheers
L.
LinkedIn
Twitter
