I'd like to graph the percent of whole using a beast mode
user060355
⚪️
in Charting
I am graphing Consultation data and one field I have access to is "excuse". I'd like to graph the percent of consultations where the excuse is "no show". I thought the following would work:
count(`id`) / sum(case when excuse = "no show" then 1 else 0 end)
But the results don't make sense. It's telling me that 35/443 = 12.66% and that 46/355 = 7.72%. I've obviously done something wrong in my case statement, I'm just not sure what it is.
0
Answers
-
Oh boy. I just realized I should have written:
sum(case when excuse = "no show" then 1 else 0 end)/count(`id`)
1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部