Changing the format of results

Have more questions? Submit a request

5 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
  • Rebekah S

    Does this not work on custom metrics and/or KPI visualizations?  I have a custom metric ("Contribution") that I'm trying to color-code and give a simple +/- prefix to, but it refuses to display the format:

    IF (SUM(Contribution) > 0) THEN
    {
    "prefix": "+",
    "fontColor": "#bc3030"
    }
    ELSE
    {
    "prefix": " ",
    "fontColor": "#2db52f"
    }
    ENDIF

    0
  • Molly VS

    Hey Rebekah!

    I checked with our team on this and does seem like this feature isn't applicable on KPI Visualizations currently. They recommended that you suggest this on our Product Feedback page as a feature you'd like to see. 

    0

Please sign in to leave a comment.

Powered by Zendesk