Changing the format of results

Have more questions? Submit a request

16 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
  • Christopher C.
    Comment actions Permalink

    Nothing in this post works when applied to explore reports, even when copying and pasting.

    0
  • Brett - Community Manager
    Comment actions Permalink

    Fiona I confirmed with one of our Explore experts and it doesn't look like there's a way to center this in the widget at this time.

    Let me know if you have any other questions for me! 

     

    Christopher C. are you receiving any sort of errors when trying to copy and paste the formula? Any additional information you can provide is greatly appreciated.

    Thanks!

    0
  • Christopher C.
    Comment actions Permalink

    Hello Brett,

    Even when I open the Display format>Advanced and change nothing, it already gives an error.

     

    0
  • Brett - Community Manager
    Comment actions Permalink

    Thanks for the update Christopher!

    Definitely odd that you're receiving this error.

    I'm going to generate a ticket on your behalf so our Customer Advocacy team can look into this with you.

    You'll receive an email shortly stating your ticket has been created.

    Cheers!

    0
  • Juan Arias
    Comment actions Permalink

    Hi all,

    I have found conditional formatting is not possible when the metric name includes parenthesis. Is there any workaround besides renaming the metric / creating a new one for build-in metrics?

    Your help is greatly appreciated.

    0
  • Devan
    Comment actions Permalink

    Hello Juan Arias,

    We are going to be opening a ticket on your behalf so our dev team can look into this more. Right now, there is no workaround for this issue, but we hope to resolve this with you shortly. You should receive an email followed by a response from our dev team soon. 

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk