SAM KPI Widget

Hi all, need some assistance please creating a modern dashboard KPI widget for Application Availability and KPI Widget showing Up/Down

The following returns the value, any way for it to display Up or Down?

SELECT count(1) as count_apps From orion.Apm.Application where DisplayName = 'SolarWinds Health' AND statusDescription = 'Up'

OR 

SELECT count(1) as count_apps From Orion.APM.Application where DisplayName = 'SolarWinds Health' AND Status = '2'

Thanks

Parents Reply Children
No Data