Forum Discussion

Kapilchauhan555's avatar
Kapilchauhan555
New Member
2 years ago

Kpi alert for zero rows in table

I have a table where I receives daily order

I am using kpi visual to generate alerts if count of order is below 20 orders . But the alerts is not generating if the count of order is 0 . I need count and date on tile so need a solution for kpi visual

1 Reply

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional

    If you add +0 to the end of the measure you're using for your KPI card, it will return 0 instead of blank. Since that is a number and not null, it should let the alert trigger.