Grouped Percentages
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
Best Answer
-
BETWEEN is not supported in beastmodes only in Magic ETL formula tiles. You will need to rewrite the beastmode to be:
CASE
WHENKPI Attainment %
>= 0 ANDKPI Attainment %
< 25 THEN '0-24%'
WHENKPI Attainment %
>= 25KPI Attainment %
< 50 THEN '25-49%'etc…
If I solved your problem, please select "yes" above
0
Answers
-
BETWEEN is not supported in beastmodes only in Magic ETL formula tiles. You will need to rewrite the beastmode to be:
CASE
WHENKPI Attainment %
>= 0 ANDKPI Attainment %
< 25 THEN '0-24%'
WHENKPI Attainment %
>= 25KPI Attainment %
< 50 THEN '25-49%'etc…
If I solved your problem, please select "yes" above
0 -
Legend thankyou
0 -
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
0 -
Ignore my last, I resolved the issue thanks
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive