Changing the format of results

Return to top


  • Antonio

    As Chris said 2 years ago, I'd also like to apply conditional formatting to Attributes, specifically for satisfaction ratings: if it says Good, then it's green, and if it says Bad, then it's red. Just like the way the old Satisfaction tab used to look like! 

    I'm being forced to re-build it from scratch, and it's a pain that I don't have all the functionality that I used to have.

  • Chris Bulin
    Community Moderator

    Hi Antonio Rodríguez Rasero! It's not exactly the same, but I did find a way to create similar functionality in my CSAT board. I wrote it up as a tip here: 


  • Jed Hollander

    How can I reformat the result of a custom-calculated attribute? IE I have a result of 35000 but want it formatted $35,000?




  • Elaine
    Zendesk Customer Care

    Hi Jed,

    Right now, I'm not sure if you are referring to a calculated attribute or a calculated metric because of the numeric result you have mentioned.

    I think I need to look closer into your account, specifically the calculated attribute that you mentioned.

    I'll go ahead and create a ticket on your behalf. Kindly wait for a notification within your email. :)

  • Kai Schmitte

    Is there a way to automatically adapt my dashboard data so that the results fit to different handling of thousands separator and decimal separator? 

    We are an international company and some users have set up their OS and Excel to use the the dot as thousands separator and the comma as decimal separator - and some exactly the other way round. 
    Expectation would be that users set up their output format in a central place and that all queries respect this output format. 

  • Johannes Sidarta


    Can I use different colours dependent on the row criteria (rather than based on the metric only)?


    The following is what I have:

    - Metric: Med (First reply time - Business hours)

    - Row: Ticket Priority



    What I want is:

    - If the Ticket Priority is High and First Response is more than 2hrs, to make it red; within 1-1.9Hrs blue; otherwise green

    - If the Ticket Priority is Normal and First Response is more than 8hrs, to make it red; within 4-7.9Hrs blue; otherwise green

  • Elaine
    Zendesk Customer Care

    Hi Kai,

    This is not something that is natively available within Explore at the moment.

    I highly suggest you submit a feature request and provide further information for your use case for our Product team to review. Stay safe! :)

  • Elaine
    Zendesk Customer Care

    Hi Johannes,

    Currently, conditional formatting is only available for metrics and not for attributes.

    For the metric that you're trying to change the display format, I highly suggest you check out the article Conditional formatting doesn't change the color of the cells.

    Below is an example of how I did the conditional formatting for this metric:

    Hope this helps! :)

  • MAD Monica Maldonado


    Is there any way to exclude totals from the conditional formatting?

  • Dane
    Zendesk Engineering
    Hi Monica,
    Unfortunately, whenever you use conditional formatting the "Totals" will also be part of it and therefore, there's no way to exclude it. The only alternatives are to remove the totals from the query or include additional logic in the conditional formatting to remove the color when the totals exceed a certain value.
    Zendesk | Customer Advocate
  • DJ Buenavista Jr.
    Zendesk Customer Care
    Thank you for reaching out to Zendesk Support.
    In regards to your concern, there's no native feature of this in Zendesk as of the moment. This might be achievable through a custom formula, which unfortunately we don't support.
    I would highly encourage you to post this as product feedback in our Zendesk Explore feedback page. This will help our devs and managers to see what features our customers would like to add in our product to improve our service.
    Thank you and have a wonderful day ahead!
    Kind regards,
  • Judd Higgins

    Adding my plus one to allow formatting for calculated attributes. I don't want to see that it's been 272.3345456467 days since the last reply. I want the calculated attribute to display whole numbers. This is basic formatting stuff.

  • Ronald

    I would like to add formatting to the last two metrics in my table. These are total and rate metrics which are computed from the other metrics in the table. 

    Apparently I can't format these because "Advanced display format is not available with result metrics."

    This is unfortunate for me because these are the only rows that I want to format. Seems like the result metrics representing totals would always be the most probable candidates for conditional formatting, so this limitation is particularly odd.

  • Hamish Lang

    Pretty wild the lack of conditional formatting available for attributes and just the whole table itself. 

    Please take some inspiration from Google Sheets in terms of the ease of functionality to set this up in GUI rather than having to manually code everything. 


Please sign in to leave a comment.

Powered by Zendesk