Changing the format of results

Return to top

8 Comments

  • Antonio Rodríguez

    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.

    0
  • 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: https://support.zendesk.com/hc/en-us/community/posts/360052186773-How-to-recreate-the-Insights-CSAT-dashboard-in-Explore 

     

    1
  • 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?

     

    Thanks.

     

    0
  • 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. :)

    0
  • 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. 

    0
  • Johannes Sidarta

    Hi,

    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

    Example:

     

    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

    0
  • 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! :)

    0
  • 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! :)

    0

Please sign in to leave a comment.

Powered by Zendesk