Changing the format of results

Have more questions? Submit a request

10 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
  • Fiona
    Comment actions Permalink

    Hi! Is there a way to center a table to the middle of the widget? My tables are always left aligned in the widget and I don't like it, haha. Thanks!

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Fiona,

    Any chance you could provide a screenshot of what you see on your end so we're both on the same page?

    Let me know!

    0
  • Fiona
    Comment actions Permalink

    Hi Brett

    Thanks! Please see below. I would like the table to be in the middle of the widget, not to the left. Thanks again!

    0

Please sign in to leave a comment.

Powered by Zendesk