I have a report in Looker Studio which pulls from BigQuery and it is not aggregating metrics by dimension. When I sort by a column, suddenly it is doing the aggregation correctly.
For example, if each row is an order and there are dimension values a, b and c which should aggregate value x, it's not combining the rows with similar values for a, b and c into one row with aggregation of values x until I sort by dimension b.
This seems like a bug in Looker Studio, but I wanted to see if others have encountered this and if there is potentially something wrong I am doing or if there is a workaround for now.
LinkedIn
Twitter
