Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input
{AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB
{637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB
Page 1 / 1
Hi Lisa,
when you wrap the SUM() around the CASE WHEN it should work. So it should look like SUM(CASE WHEN... THEN ... ELSE... END)
BR
Kevin
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.