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

Have more questions? Submit a request

7 Comments

  • Cesar Jimenez
    Comment actions Permalink

    Does this recipe work with all metrics? I'm trying to use it with the "Unsolved tickets age (days)" metric but the background color is not changing.

    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

    0
  • Fernando Duarte
    Comment actions Permalink

    Zendesk support said that color customization is not supported

     

    0
  • Ricardo
    Comment actions Permalink

    Hello Cesar Jimenez! Thanks for raising this. I recreated the query but this time using the metric Unsolved tickets age (days) and using your conditional formatting. I had the same issue you had. I reached out to our Explore team and apparently there is an issue with the use of brackets in the title of the metric because they are seen mathematically.

    To solve this issue, duplicate the metric Unsolved tickets age (days) and leave the brackets out of the new name.

    Let me know if this helps please!

    0
  • Cesar Jimenez
    Comment actions Permalink

    Thanks Ricardo I found that workaround last night as well.

    1
  • Bill Cicchetti
    Comment actions Permalink

    In this day and age I wouldn't expect someone having to go through this much to alter the color.  IMO users trying to create a report wouldn't have the skill set to right out code such as above to accomplish a color change.

     

    So is this this the only way to alter the color of results?

     

    0
  • Devan
    Comment actions Permalink

    Hello Bill Cicchetti,

    I understand that this process can prove less than intuitive in its current rendition. I would recommend posting in our product feedback forums since this would be the place where our developers look for feedback on ways to improve the product. As for now, the workaround share would be your best bet for accomplishing this.

    Best regards.

    0

Please sign in to leave a comment.

Powered by Zendesk