Changing the format of results

Return to top
Have more questions? Submit a request

33 Comments

  • Aric Hoeschen

    I'm unable to provide a rule based on percentage. I am hoping to insert a conditional formatting rule that highlights any cell >90% - Green and any cell <90% - Red. 

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Aric,

    I've provided an example of how conditional formatting would work for percentages below:

    IF (SUM(% Engagement satisfaction score) < 0.9) THEN
    {
    "backgroundColor": "#FF5733",
    "precision": 2,
    "scale": 0.01,
    "suffix": "%",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": TRUE
    }
    ELIF (BETWEEN((SUM(% Engagement satisfaction score) ), 0.9 ,0.95)) THEN
    {
    "backgroundColor": "#FFC300",
    "precision": 2,
    "scale": 0.01,
    "suffix": "%",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": TRUE
    }
    ELIF (SUM(% Engagement satisfaction score)>0.95) THEN
    {
    "backgroundColor": "#19C700 ",
    "precision": 2,
    "scale": 0.01,
    "suffix": "%",
    "decimalSeparator": ".",
    "italic": FALSE,
    "bold": TRUE
    }
    ENDIF

    I hope this points you in the right direction!

    0
  • Jesse Marion

    Hello, I am wondering if it is possible to do conditional formatting in Advanced display format for Ticket handling time.

    I recreated 

    'Ticket handling time min' so there are no parenthesis to error out which I am able to achieve colour formatting.

    My issue is the second's column since it is based on 100 rather than 60 I can have results of '3:80', rather than the true time of 3:48 - is this possible?

     

    Formula:

    IF (AVG(Ticket handling time min) > 5) THEN
    {
    "backgroundColor": "#EE6363",
    "precision": 2,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ":",
    "fontColor": "#000000",
    "italic": FALSE,
    "bold": TRUE,
    "suffix": ""
    }
    ELIF (BETWEEN(AVG(Ticket handling time min), 3, 5)) THEN
    {
    "backgroundColor": "#FFC83D",
    "precision": 2,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ":",
    "fontColor": "#000000",
    "italic": FALSE,
    "bold": TRUE,
    "suffix": ""
    }
    ELIF (AVG(Ticket handling time min) < 3) THEN
    {
    "backgroundColor": "#00D364",
    "precision": 2,
    "scale": 1,
    "prefix": "",
    "decimalSeparator": ":",
    "fontColor": "#000000",
    "italic": FALSE,
    "bold": TRUE,
    "suffix": ""
    }
    ENDIF

     

    Thank you in advance

    0

Please sign in to leave a comment.

Powered by Zendesk