Grouped Percentages

AUsher2511
AUsher2511 Member
in Beast Mode

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

image.png

Please help

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited November 15 Answer ✓

    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…

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited November 15 Answer ✓

    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…

    If I solved your problem, please select "yes" above

  • AUsher2511
    AUsher2511 Member

    Legend thankyou

  • AUsher2511
    AUsher2511 Member

    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

    image.png

  • AUsher2511
    AUsher2511 Member

    Ignore my last, I resolved the issue thanks

Categories