How to Handle Single Value Indicator When No new records fit recent days

[Eric Jacobson]

I'm using this iif("Days Since Now"< 28, 1, 2) , to bucket data into column 1 or 2. Column 1 represent the last 28 days. The indicator works great, but only if there are records returned for both buckets. Is there a graceful way to handle the case where no records meet the last 28 days bucket? Current it shows an error on the dashboard.

This is a failures in last 28 days indicator. So it works great, but only when we have failures in last 28 days, ha!