DQ+ Dashboard Cell Highlighting with Single Point Threshold Does Not Work
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.
Path :
Attached files
rule.PNG
Dashboard color coding 1.PNG
expression 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?
-
Hi Arthur,
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.
Attached files
ExecType as a Measure.JPG
ExecType Rule and Computation.JPG
Please sign in to leave a comment.
Comments
5 comments