We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

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

Comments

5 comments

  • Avatar
    Jeffery Brown

    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
  • Avatar
    Arthur Greenlee

    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
  • Avatar
    Jeffery Brown

    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
  • Avatar
    Arthur Greenlee

    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
  • Avatar
    Gerard Cafaro

    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.