Struggling to Find an overall percentage
Hi, new to domo and in particular beastmode, hoping someone can help.
I have a KPI dashboard consisting of 30 plus customers and i want to find out the percentage of overall customers that meet or overachieve their KPI attainment each month. For example, if I have 10 customers and 5 meet or overachieve kpi then I'd like to see a card showing 50%.
I've been using this formula (SUM(Attained
) / MAX(KPI
)) * 100 which shows me percentage of KPI attainment at the individual client level, see screenshot attached.
When i try to use the following formula
( COUNT(DISTINCT CASE WHEN SUM(`Attained`) >=MIN(`KPI`) THEN
`Source` END
) /COUNT(DISTINCT `Source`)) *100
I get a an error, can anyone help?
Thanks
Answers
-
Are there multiple rows per customer? Or a single row per customer?
If single row per customer, the beastmode would be:
SUM(CASE WHEN (`Attained`/`KPI`) >= 1 THEN 1 ELSE 0 END) / COUNT(DISTINCT `Customer ID`)
If I solved your problem, please select "yes" above
0 -
Hi there,
Multiple rows per customer
0 -
Okay so they would have to hit their attainment for all of their KPI's to count as attained?
For example:
Customer A has 2 rows of data. In one row they attained and in one they didn't - overall as a customer have they hit their KPI? Would they be a 0 or a 1 in the numerator?
Customer B has 2 rows of data. In both they attained. Would they be a 1 in the numerator? A 2 wouldn't make sense to me since they only count once in the denominator. Or would they be a 2 over a 2 in the denominator?
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 611 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 717 Beast Mode
- 52 App Studio
- 40 Variables
- 671 Automate
- 171 Apps
- 448 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 118 Manage
- 115 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive