I have a KPI widget that shows a numeric field (with a few filters). How do I make it to show “0” instead of “New Data” ?
hope you are doing good.
You can do it by using the conditional formatting.
Step two Set 0 if found null .
hi @Naveed Thank you for the quick response. In my case, this is a custom field that is set to 1 (always) and the “No data” in the KPI is because after I add 3 filter conditions, there are no records that match those filters and hence “No data”. How do I fix this. ?
@Karthik1 Hmm not sure if we are able to display a 0 in that case since after you apply your filters there are no rows left to even substitute a 0 into. If I think of any ideas Ill post them here, but as of right now I dont think it’s possible.