Changing the format of results

Have more questions? Submit a request

3 Comments

  • Chris Bulin

    I want to apply conditional font colors to a result calculation, which I think should look like this:

    IF (D_COUNT(Tickets) > 50) THEN
    {
    "backgroundColor": "",
    "precision": 0,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": FALSE,
    "suffix": "",
    "fontColor": "",
    "thousandsSeparator": ", "
    }
    ELIF (IS_NAN(D_COUNT(Tickets))) THEN
    {
    "backgroundColor": "#dddddd"
    }
    ELIF (SUM(Result Path Ticket DCount)<0) THEN
    {
    "fontColor": "#FF0000"
    }
    ELIF (SUM(Result Path Ticket DCount)>0) THEN
    {
    "fontColor": "#00FF00"
    }
    ELSE
    {
    "fontColor": "#30aabc"
    }
    ENDIF

     

    However, when I try that, it is not doing anything even though I have negative (hopefully red) and positive (hopefully green) numbers in my result path calculation. What am I missing?

    0
  • Patrick Bosmans

    Hey Chris,

    I am going to spin up a ticket for you so that we can get some account specific testing on this to see what behavior is being exhibited.  You should be getting something from me shortly.

    0
  • Chris Bulin

    Is there a way to apply conditional formatting to Attributes? I'm just looking for a very simple, if the word Good is listed then it's green, and if Bad is listed it's red.

    0

Please sign in to leave a comment.

Powered by Zendesk