Trying to build an Gage indicator widget from the Plans cube based on the Plan Status. What I need is a count of Plans in a status that is "Still in Process" vs the total number of Plans (filtered by Fiscal Year).
I can get a count of the Plans easy enough. I can get the count of plans with a Status in the 3 types that are in process using a Filter. What I can't figure out is how to do both in the same widget.
What I want is a count of Plans in 3 specific status as the Values, a sum of the ask amount as the secondary value, the min 0 (easy), and the max as the count of the plans. This gage would use the dashboard filter of fiscal year. The first two are probably the same basic formula, since both need to be filtered by the Plan Status values. The rest are easy enough to do.
Suggestions on how to build this formula?
You'll want to use Filtered Values, I think. There's documentation here and I've done a quick mock up of what it sounds like you're looking for! You can import this and change the source to your Plans cube, and then you'll need to go into the formulas for the Values and adjust the filter. Filtered Values are really handy once you get the hang of them. IndicatorTesting.dash