DQ+ Dashboard Cell Highlighting with Single Point Threshold Does Not Work

Follow

Arthur Greenlee

• July 08, 2021 13:40
• Edited

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 :

DS3 Dashboards -> Business Process > 4. Dashboard > Business Capability Governance Metrics -> Business Process Field Check

 

Attached files

rule.PNG
Dashboard color coding 1.PNG
expression 2.PNG

 

1

• 

  Jeffery Brown

  • July 08, 2021 15:50

  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?

  0

  Comment actions Permalink
• 

  Arthur Greenlee

  • July 09, 2021 12:56

  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.

  0

  Comment actions Permalink
• 

  Jeffery Brown

  • July 09, 2021 19:26

  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

   

  0

  Comment actions Permalink
• 

  Arthur Greenlee

  • July 13, 2021 13:19

  Hi Jeff, 

  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?

  0

  Comment actions Permalink
• 

  Gerard Cafaro

  • July 13, 2021 14:46

  I'll create a ticket with our Support team to take a look at this. You'll have an email via the ticket shortly.

  0

  Comment actions Permalink

Please sign in to leave a comment.