Help with Subtotals repeating values

[ricardoprata]

Hello!

I have a table with two columns and subtotals applied, where the first group is showing repeated values (a simple sum measure) for all the rows except the first one.
Usually, Looker will behave badly if the query result is beyond the set limit (5k rows max), the problem is my Look is bringing 2402 rows.
I've tested the look without subtotals, and there is really only 2402 rows, and tested with just the first column to check the value, and I indeed have different values for each group.

First time encountering that, if someone can help it'll be much appreciated.


EDIT: I found a solution after messing with it. I just sorted the first group by descending order, and then by ascending again. Also, removed the null values from that column also. Seems like a bug.

[EricE]

Hello there,

It sounds like this is this is a challenge around either symmetric aggregates or subtotaling with table calculations. Thanks for the feedback on your edit post. We'll take a look at this if it's still a reoccurring issue.

Thanks!

[ricardoprata]

Hi EricE, just to let you know, I just encontered the problem again, with subtotals, after using a calculation (% of column).

Also, just sorting some fields seems to solve it, just like last time.