Explore recipe: Change color of % one-touch tickets when it reaches a certain value

Return to top

9 Comments

  • Andrei Kamarouski
    Community Moderator
    The Wise One - 2021

    Hi, 

    Does the code for formatting support extended IF statements like this? 

    IF (Metric1=X AND Attribute 1="YYY") ...
    0
  • Eric Gao

    Hi Andrei,

    The IF block does support multiple conditions on both the metrics and the attributes. That said, we recommend testing out each condition individually first before conjoining them in a single condition (using AND/OR).

    Warm Regards,
    Eric

    Eric G. Gao | Technical Support Architect | Zendesk

    0
  • Michael Fitz

    I was unable to get the color formatting working with KPI visualization type. I switched to a Table visualization and it worked. Just FYI in case anyone was having issue.

    Edit: Link to the feature request. https://support.zendesk.com/hc/en-us/community/posts/360042104174-Explore-color-conditional-formatting-is-only-in-Table-format-

    0
  • Ravindra Singh

    How to change color of Priority and Ticket solved month, in the given query, please refer snapshot of the query.

    0
  • Marco Malbas
    Zendesk Customer Care
    Hi Ravindra, at the moment there would be no way to change the colors of the columns the way the report is set up. In your screenshot, we are asking Explore to just combine two attributes and show the data. Meaning "August - Minor", "August - Serious" etc. 
     
    Unlike for example if you have the Ticket Solved - Month as a column and the Priority as a row, which would result into something like this automatically changing colors. In here, we are telling Explore to display the number of tickets being created (or solved in your case, just used created here as it has more data in my test account), and and separate them by priority. 
     

     
    Hope this helps! Cheers! 
    0
  • Monica Maldonado

    Hey, how do I write > or =?  Because here we get bigger or smaller and if the value is equal will be included as smaller. What is the simbol?

     

    0
  • Dave Dyson
    Zendesk Community Manager
    Hi Monica,
     
    You can use OR, e.g.:
     
    IF (SUM(onetouchtickets-c133534e9b) > .80) OR (SUM(onetouchtickets-c133534e9b) = .80) THEN
     
    See also Explore functions reference
    1
  • Monica Maldonado

    Hi Dave, 

    Thanks for answering. 

    I tried but it didn't work to me. So i decided just put a number behind, like the last number i want to have red. i.e. .69 when your target is 70. That works too.

    Have a great day

    0
  • Monica Maldonado

    Hi,

    Do you know any way of excluding Totals from the formatting?

     

    0

Please sign in to leave a comment.

Powered by Zendesk