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 month the guage shows as Blank, I am assuming this is just because theere arent any calls that have breeched their SLA target, but if possible I would like the guage to show at 100% until the calls start breeching.

 

The gauge is based on the following 

 

RESOLUTIONSuccessRate =
CALCULATE(
    COUNTA(opencall[ResSLA]),
opencall[ResSLA] ="Achieved SLA") /
     CALCULATE(COUNTA(opencall[ResSLA]))

 

Any help on achieving this would be really appprechiated.

 

Cheers

RC

 

 

 

 

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.

3 Replies

  • 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?