Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with gauge showing blank values

Hi    I could do with some help with a guage visulisation    The guage is showing the % of tickets that have been resolved withtin their SLA during a selected month    At the beggining of the m...
Need Help
  • evandrocunico's avatar
    evandrocunico
    7 years ago

    Hi Anonymous , 

     


    RESOLUTIONSuccessRate = var __SLA = CALCULATE(COUNTA(opencall[ResSLA]),opencall[ResSLA] ="Achieved SLA") / CALCULATE(COUNTA(opencall[ResSLA]))
    var __result = if (ISBLANK(__SLA);1;__SLA)
    return __result

     

    regards.

evandrocunico's avatar
evandrocunico
Icon for Resolver III rankResolver III
7 years ago

Hi Anonymous , 

 


RESOLUTIONSuccessRate = var __SLA = CALCULATE(COUNTA(opencall[ResSLA]),opencall[ResSLA] ="Achieved SLA") / CALCULATE(COUNTA(opencall[ResSLA]))
var __result = if (ISBLANK(__SLA);1;__SLA)
return __result

 

regards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hero!

     

    Thanks you so much for your help!

     

    RC

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    whereabouts exactly do you enter the script.
    I have the same issue but I’m just creating a gauge using the drag-and-drop functionality.
    Where do I apply a script solution?