Downtime as KPI chart

[Karthick30]

Hi,

 I have a downtime(HH:MM format) for cities which went down in past years. How to convert it KPI (Availability of Sites) in % value , which will change based on my filters(Year,Month, Week,day). 

Any help will be greatly appreciated

[JordyWegman]

Hi Karthick,

Not sure how your data looks like, but you define the:

(Available minutes ) / ( total sites * total available minutes per site )

Jordy

Climber