Hi #C01P3H2HTDL I have a metric as following: Active Contacts (last month) SELECT MAX(ActiveContacts) WHERE Month - Month/Year = PREVIOUS(MONTH) I’m trying to create visualization to arrive at those list of customers that have Active Contacts (last month) count as less than 10…However, it is not including those that have Active Contacts (last month) as 0 despite me checking “Treat blank values as 0” in the filter

Hi Rishi, it should be possible to check the “treat empty values as 0” directly in the numeric filter. That way it should also return empty values. Alternatively you can add IFNULL() function to your metric.