I noticed there was a post awhile ago which asked how to aggregate the categories for fruit. I tried to follow this in my calculation, however the calculation doesn’t want to work because I am giving the expression 4 arguments over 3.
My data looks like the following:
NPS ORDINAL|NPS NESTED CALC|COUNT
I want to calc the total number of promoters, detractors and passives and put this on a stacked bar chart to show distribution.
I am not sure if this is possible via calculations but I do not have access to lookml and I am fairly new to Looker.
Any help would be much appreciated!