Changing the format of results

Return to top
Have more questions? Submit a request

32 Comments

  • Chris Bulin
    Community Moderator

    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
    Zendesk Customer Advocate

    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
    Community Moderator

    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.

    2
  • 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
    Zendesk Customer Success

    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

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

    1
  • Rob Stack
    Zendesk Documentation Team

    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

    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 Bowser
    Zendesk Community Team

    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

    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.

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

    0
  • Brett Bowser
    Zendesk Community Team

    @... 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.

    Hello Brett,

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

     

    0
  • Brett Bowser
    Zendesk Community Team

    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

    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 - Community Manager
    Zendesk Community Team

    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
  • David Pritchard

    I have two queries that calculate the difference between created tickets and solved tickets for Agents and End users. I want the background to change colour based on the result, for example:

    • 10 tickets created and 5 tickets solved = 5 (I want the background colour to change to red)
    • 10 tickets created and 15 tickets solved = -5 (I want the background colour to change to green)

    I have read the above post and get this "Advanced display format is not available with result metrics". Even the most budget of excel rip offs have a feature that formats a result based on criteria so why cant i do it?

    I find quite a large number of things on Zendesk (Explore and Support) very limiting and for a system as powerful as it is, the basics seem to have been overlooked making it not very user friendly in certain instances.

    0
  • Chris Bulin
    Community Moderator

    David Pritchard I was able to get mine to work. Here's what I used: 

    IF (SUM(Result Path Ticket DCount) > 0) THEN
    {
    "backgroundColor": "#ffffff",
    "precision": 0,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": TRUE,
    "suffix": "%",
    "fontColor": "#00FF00",
    "thousandsSeparator": " "
    }

    ELSE
    {
    "backgroundColor": "#ffffff",
    "precision": 0,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": TRUE,
    "suffix": "%",
    "fontColor": "#EB4962",
    "thousandsSeparator": " "
    }
    ENDIF

    This turns anything zero and below red, and above zero green. If you have two different calculations, you would need to add it to the Display format for each. 

    0
  • David Pritchard

    Chris Bulin I have no option to enter that anywhere

     

    0
  • Chris Bulin
    Community Moderator

    Hi David Pritchard thank you for the information. I use mine on a calculated metric rather than a result metric calculation. It looks like you can't use the custom formatting on result metric calculations. 

    0
  • MiiiA Pty Ltd

    Hi all, I've just converted my first Dashboard over from Insights into Explore. Was quite a challenge to get my head around all the new features, but so far I'm liking it, and far better than having to jump into Good Data.

    I have one issue I'm not sure if we're able to resolve as yet.
    I would like to display/format my Update handling time (mins) metric to display in Hours and Mins as per my screenshot:

    In the old Insights I think we just used a string formatter like this: 

    {{{||0}}} h {{{0.0166666666666|60.|00}}} m

    Any ideas if this is possible in Explore advanced formatting formulas?


    Thanks
    Dan

    0
  • Chris Bulin
    Community Moderator

    Hi Dan! You can use the Duration Display Format to get the format to display into dd:hh:mm. Alternatively, you could use the Custom option and set 2 decimal places and a suffix. Neither of those exactly duplicate what you have, but they are the closest I can think of. I checked to see if there was any documentation about this, but they all refer back to using the Duration format.

    0
  • MiiiA Pty Ltd

    Thanks Chris Bulin yes I can certainly get the duration working.

    I guess I was hoping that the Advanced formulas for formatting could help here, but everything I've tried doesn't seem to work.

    I know in EXCEL if I had my Metric in HOURS I could do something simple like this:

    =IF(HOUR(C4)>0, HOUR(C4) & " h","") & IF(MINUTE(C4)>0, MINUTE(C4) & " m","")

    Perhaps given so much of our SUPPORT ticketing is in minutes/hours the product team may add a few more possibilities for displaying time when converted from the standard minutes that most Support ticket metrics are available in.

     

    0
  • Chris Bulin
    Community Moderator

    I know what you mean Dan. For a hot minute I thought I could split the time on the colon and creating separate columns for hours/minutes like I do in Tableau, but sadly, that functionality does not exist (yet?) in Explore. Would be nice if it did.

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi all, please do consider sharing this feedback in our community forum to give it more visibility to the product groups! - https://support.zendesk.com/hc/en-us/community/topics/360001200913

    0
  • MiiiA Pty Ltd

    Thanks Rob.

    I've created a post in the Explore Feedback forum

    https://support.zendesk.com/hc/en-us/community/posts/360049081154-Custom-Format-for-MINUTES-display-X-h-X-m-


    Dan

    0
  • Elene PECK

    Hi,

    I am new to Zendesk Explore and just created a query.

    I have put as 0 decimal place for the ticket age metric result and it works in the dashboard. However, the data exported in excel format has many decimal places for ticket age field. May i check how can i format the excel report to be similar to the dashboard result? i.e. no decimal places for the field.

    Is it possible to do simple formatting of the exported data in excel format during the schedule delivery of the file?

    Thanks in advance for your help.

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Elene,

    I went ahead and answered your question here: how to remove decimal places when exporting ticket data?

    I hope this helps!

    0
  • Konstantin Annikov

    Is it possible to change metric's color based on the average in the column?  Like that: 

    1
  • Devan - Community Manager
    Zendesk Community Team

    Hello Konstantin Annikov,

    I checked with our product team, and this currently isn't a feature on our roadmap or something you can do natively. I've passed this on to our developers, but I would recommend sharing your use case in our product feedback forum.

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk