Grouping rows

[richardptr]

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

[Dawid]

You have to remove “ALL TEAMS” field as this is the granularity of your data.

[richardptr]

Hi @Dawid , following up on my previous question to see if you can assist. Thanks ?

[Dawid · Accepted 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