Combine multiple Line Items using Table Calculations

[LookerExperts]

Knowledge Drop

Last tested: Apr 24, 2020
 

Usually, if I have a list of dimensions and measures, if I want to change the group by I would use a case when in LookML, but what happens if I do not have access to LookML? Who do I call?

In a series of table calculations, you can alter the grouping.

In the example below, I wanted to combine the counts for dogs named Princess and Buddy. I wanted to replace the Princess count with this new combined count, then hide the original count for dogs named Buddy.


Original Explore:

This table calculation grabs the values from dogs name Buddy and Princess and puts them in a new column. All other row values are zero.





This lets us replace the dogs' named Princess value, with our combined value from before:

This allows us to hide the original Buddy value from the visualization.

Here is our final result:

This content is subject to limited support.