On our dashboard we are unable to get any cells to be highlighted with the following single point threshold. The cell should be highlighted if the value in PopulatedPercentage is less than 50%. But with the following expression none of the cells are highlighted.
rule.PNGDashboard color coding 1.PNGexpression 2.PNG
Hi Arthur... I have an obvious question that might just me missing something, but in "Dashboard color coding 1.png" all of the values are over 50, so they would not be highlighted. I assume there are other values below 50 that are not highlighted. Also, have tried .5 instead of 50?
There are many other values that aren't highlighted which are beyond that range. And I have tried many different other values for the expression to no avail.
A threshold can only be applied to a field that is on the y-axis (which makes it a measurement). So to make it work, you can add the fields you want to highlight as a "measure" on the y-axis and use that in the data grid too. You can then also choose that field on the y-axis as your Compute field when creating the rule (see screenshots). In my example below, I use ExecType as the field I am adding threshold rules too.
ExecType as a Measure.JPGExecType Rule and Computation.JPG
I followed you directions to try and copy the images and simplified the expression to get it to highlight anything and it still isn't working :(. Perhaps a call? Should I switch this to an error?
I'll create a ticket with our Support team to take a look at this. You'll have an email via the ticket shortly.