Recent searches


No recent searches

Changing the format of results



image avatar

Rob Stack

Zendesk Documentation Team

Edited Jun 21, 2024


5

15

15 comments

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


image avatar

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


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


image avatar

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


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. 

1


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


image avatar

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

-1


image avatar

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

-1


Hi,

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

0


image avatar

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.
 
Cheers,
Dane
Zendesk | Customer Advocate

-1


image avatar

DJ Buenavista Jr.

Zendesk Customer Care

Hi,
 
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,
 
 

-2


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.

4


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.

1


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. 

3


Thousands separator defaulting to a space for me. That seems very strange and unhelpful, since I have to customise every value that may exceed 999 units. Can you please make it a global setting that gets applied to the standard or default the thousands separator to nothing please (ie not a space)?

0


Please sign in to leave a comment.