Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We use a field "Stage" to track where a sale is from start to finish. There are about 30 different values for Stage, but the main five are
00 - Lead, 20 - Sales Opp, 40 - Discovery, 60 - Solution, 80 - Forecast Sale.
My dimension is:
If(mixmatch(left(STAGE,2),'00','20','40','60','80')>=1, STAGE, Null()),
with "Suppress if value is null" selected. Works great, if the rep has a sale at every stage.(the only expression is "Sum(Forecast)")
However, if a rep has no opportunities at, say, 40, that value doesn't show up in the chart, eg:
I've unchecked "Suppress Zero Values" and "Suppress Missing" on the Presentation tab. Is there any way to show the missing stages with a total of $0?
Hahahaha ya