Help with gauge showing blank values

[Anonymous]

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

[evandrocunico · Accepted solution]

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]

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?

[Anonymous]

Hero!

Thanks you so much for your help!

RC