Hello,
I’m reaching out for some help on how to aggregate rows in order to correctly display them in a chart. I was able to group Teams 6A, 6B and 6C into Team 6 but need some help aggregating the three “Team 6” rows, any help is welcome. I have used “if(contains(...” on my initial calculation.
Thanks in advance,
Richard
Solved! Go to Solution.
You can’t group data by your derived field if you have a lower granularity field present in your query. You’d have to create your grouping in LookML not using table calculations
You have to remove “ALL TEAMS” field as this is the granularity of your data.
Hi @Dawid , following up on my previous question to see if you can assist. Thanks ?
You can’t group data by your derived field if you have a lower granularity field present in your query. You’d have to create your grouping in LookML not using table calculations