Grouped Percentages

AUsher2511

Hi All,

I have a created a table where I can see customer, their KPI, KPI attainment and KPI attainment %.
I want to group the clients by KPI attainment % for example, a list of customers that fall into brackets such as

0-24%, 25-50%, 51-74%, 75-99% etc etc.

I'm using the following beastmode but it keeps returning a syntax error that I jjust can't fix

CASE
WHEN KPI Attainment BETWEEN 0 AND 24 THEN '0-24%'
WHEN KPI Attainment BETWEEN 25 AND 49 THEN '25-49%'
WHEN KPI Attainment BETWEEN 50 AND 74 THEN '50-74%'
WHEN KPI Attainment BETWEEN 75 AND 99 THEN '75-99%'
WHEN KPI Attainment BETWEEN 100 AND 124 THEN '100-124%'
WHEN KPI Attainment BETWEEN 125 AND 149 THEN '125-149%'
ELSE '150%+'
END

Please help

ColemenWilson

BETWEEN is not supported in beastmodes only in Magic ETL formula tiles. You will need to rewrite the beastmode to be:

CASE
WHEN KPI Attainment % >= 0 AND KPI Attainment % < 25 THEN '0-24%'
WHEN KPI Attainment % >= 25 KPI Attainment % < 50 THEN '25-49%'

etc…

ColemenWilson

BETWEEN is not supported in beastmodes only in Magic ETL formula tiles. You will need to rewrite the beastmode to be:

CASE
WHEN KPI Attainment % >= 0 AND KPI Attainment % < 25 THEN '0-24%'
WHEN KPI Attainment % >= 25 KPI Attainment % < 50 THEN '25-49%'

etc…

AUsher2511

Legend thankyou

AUsher2511

Quick question, when I try and use this in a table every customer shows as 0-24%, when there are customers that should be in other brackets? (Apologies I'm new to DOMO beastmodes) See screenshot

AUsher2511

Ignore my last, I resolved the issue thanks