Another solution - could be to create a drop down with 5 elements:
- Exceptional
- Passing
- Not Passing Standard
- NO GO
- All
And then have a filter interaction on the click event of the drop down - filtering the average score on the same values you use when setting up the states.
So if this is how you define your states:
if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) >= .98)
{return “Exceptional”;}
else if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) >= .965)
{return “Meeting Standard”;}
else if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) > 0)
{return “Not Meeting Standard”;}
else {return “No Go”;}
You would instead create a formula in the metric set like this:
if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) >= .98)
{return 3;}
else if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) >= .965)
{return 2;}
else if (Math.Round(AVG($Average Score$,$Assoc + Username$,$audittype$),3) > 0)
{return 1:}
else {return 0;}
And then hide this formula expression column in the table
Then create a single number filter (so you get a viewparameter on it) and drag it off canvas (or just hide the control).
So here’s my example (just created a data set real quick for illustration purposes so my states are not exactly like yours)


Hope it might be useful for you 