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!