How to get % of total in Nested Bar and Line Chart
I'm trying to utilize the nested bar and line chart to determine to show how many of our signed staff actually start vs. drop out in onboarding. Currently, I have the chart as a nested bar and it works well but when I switch it to nested bar and line, I'm not able to achieve my goals. As some background, the current chart is:
- x axis is signed offer date over time
- y axis is count (employeeID)
- series is onboarding status (and the onboarding status fields are started, future start and did not start) which provides me 3 bars showing how many are in each.
The goal is to leave that chart intact but add a line overtop that is % dropout rate with the calculation being onboarding status=did not start divided by the total of the nested bar (i.e. started + did not did + future start).
If anyone has any ideas here, that would be greatly appreciated.
Thanks!
Answers
-
You could try something like this:
sum(case when `onboardingStatus` = 'did not start' then 1 else 0 end) / (sum(sum(case when `onboardingStatus` in ('started','did not start','future start') then 1 else 0 end)) over (partition by year(`signedOfferDate`), month(`signedOfferDate`)))
0 -
Hi - thanks for the reply. It did not work though. I've attached the formula and what the chart looks like using that formula. I also attached the baseline chart - that has everything except the dropout rate (line).
Any help would be greatly appreciated.
0 -
I think there's more than one thing going on, but I would start by playing with your sorts. I don't think you want a sort on Onboarding Conversion status, which is what's causing the duplicate dates across your x-axis.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
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