Update funnels to return 0 for steps with no data
Problem to solve
When funnels render in the UI, it will only show steps that have data.
The impact is that users cannot see the drop-off nor the context of the full journey so only showing the first step has little value.
The cause is that if a step hasn't been reached, then it doesn't get sent back by the API response to be rendered with a 0
value.
For instance, this funnel has two steps, but because only one of the steps has been reached, it will only render that column:
0: view_dashboards_list
1: view_all_the_things_dashboard
Proposed solutions
- Update the Cube proxy data transformer to “zero-fill” all steps.
- Update the funnel model to add
0
values to steps in the window that have no data.
Edited by Jiaan Louw