How to change the KPI score from NA to normal if no data is coming.

[veerendra_modi]

We have KPIs setup for a service, whats happening is the Service health is calculated on the basis of the KPis getting the data, what we want is that the KPIs that are NA or not getting any data should be considered as Normal criticality while calculation of service health.

[nickhills]

Hi @veerendra_modi
Try something like this:

...your search which provides a value
|stats count(something) as kpi
|eval kpiResult=coalesce(kpi,"Normal")
|table kpiResult