I'm putting together a 'Sales Funnel' in the Analyze Reporting, and would like to do it on workflow status. I'd like to use multiple workflows (let's call them an early-stage and a mid-stage workflow) to show the full life from Idea to Proposal.
I've chosen to use the Project Status and Task Status variables in the Values section of a Bar Chart. I use a formula like
(count([Project Name]),[Project Status1])
and repeat this formula for each status to depict the distribution of Projects from beginning to end of the Sales Funnel.
The issue is that when filtering by status, I can only select for statuses that are have at least one observed instance in the chosen data set. So, if I have three consecutive status':
and none of my projects are in 'Scoping', then my funnel chart will not show Scoping with zero projects next to it. As a sales funnel, I might have 10 projects in New and 10 in Review, and it will show I'm doing fine. But really, I have nothing in the intermediate step.
Does anyone know a workaround, or can point out what I'm missing? Cheers