Question
Aggregate Value Bucketing Across Levels
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.