I've created a Summary Report: limited by the lead type and the create date range in question, then summarized by our "qualified / non-qualified" marker. And I can get the %'s for my summary groupings to display on the report by creating adding this formula "RowCount/PARENTGROUPVAL(RowCount, GRAND_SUMMARY)".
So is there a way I can grab only the % "Qualified" to be the number displayed on a Gauge Chart?
Note that the breakpoints for the gauge are percentages themselves. i.e. if our goal is 50% of leads are qualified, then .5 would be breakpoint2 for the start of our green range.
Is there some other approach I'm missing; in Excel I would just do a Count if "Qualified" over Count. I don't have a lot of experience with custom formulas, so I have this sneaking feeling that I've gone down the wrong rabbit hole with this approach.
Thanks in advance for the help,
Robert
