Changing the format of results

Have more questions? Submit a request

7 Comments

  • Chris Bulin
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
  • Daniela Sanguino
    Comment actions Permalink

    Hi! Is there a way to align the text of the table to the center?

    1
  • Rob Stack
    Comment actions Permalink

    Daniela Sanguino

    Hi Daniela, yes there is!

    After you create a table, in the Chart configuration menu, click Columns.

    On the Columns page, make sure that Automatic alignment is not checked. Then, you'll see that for each column, you can change the text alignment.

    I hope this helps and I've put that in the queue for an update to the docs soon! Thanks for bringing this up.

    0

Please sign in to leave a comment.

Powered by Zendesk