Recent searches
No recent searches
Explore:Simplify the process of colorization of results
Posted Jun 25, 2020
I am requesting that the process of setting the color of the returned data in a report based on a value be simplified.
Currently in order to set the color of s result based on the value returned you have to use code such as seen here:
IF (AVG(Unsolved tickets age (days) > 7) THEN
{
"backgroundColor": "#EE0E0E",
"precision": 0,
"scale": 1,
"prefix": "",
"decimalSeparator": ".",
"fontColor": "",
"italic": FALSE,
"bold": FALSE,
"suffix": "",
"thousandsSeparator": " "
}
ELSE
{
"fontColor": ""
}
ENDIF
In my opinion the everyday report writer does not have the skillset to write something like above. Nor no I feel one should have to go through all f the above on each report (if the colors used are different or the baseline value different) for something as basic of setting a color pattern. In addition, at the time of this post, ZD Support did not support custom colorization.
There is already tools to restrict reports to particular values. We should be able to designate colors for ranges of values also.
19
10 comments
Official
Eugene Orman
Thank you for the great feedback. Please continue voting for this feature if it is important to you.
We will consider providing more simple color coding in the New report builder version. However, this will take time because we are still working on bringing the most common reporting features into the new version of the builder.
0
Viorica Pop
Hi Bill -
We are in the same situation - we are also using coloring for KPIs. Do you mind detailing where you place the code above?
Thanks!
0
bill cicchetti
Hi Viorica,
Here is a link to a article with information on the process
https://support.zendesk.com/hc/en-us/articles/360047788473-Explore-recipe-Change-color-of-one-touch-tickets-when-it-reaches-a-certain-value
0
Devan La Spisa
Thanks @...!
0
Antonio
Upvoting this! It's way too complicated
0
John Morrison
I agree. There has to be an easier way to color code reporting results.
0
Luke Tyhurst
Zendesk, can we please get an update on this feature request? For example, it is currently not possible to encode color based on the Priority field, even though that is seemingly a pretty normal use-case. Color can make a huge difference on how useful a report is, so this is a pretty important feature.
0
CJ Johnson
Not only is complicated, it's been completely broken for all time based metrics for 6 months. I've given up on building any of the reports that were requested to have color added in January, because the dang color encoding is broken for all of them right out of the box:
I would be delighted to have *any* functional color encoding at this point.
1
Chris Wooten
Zendesk Any look at updating this?
0
Charity Ponton
Also looking for a way to color code tickets. It would be especially helpful to have a ticket tagged as a VIP customer to color and catch the eye for quicker support
0