Grafana detecting NULL values as ''

Grafana
1

Hey there,

I have this code:

SELECT netype, sum(setup_attempts) as setup_attempts
FROM o_performance_metrics.business_calls_summary_monthly
WHERE date = TO_DATE(CONCAT('01 ', 'Dec 2023'), 'DD Mon YYYY')
  AND (
    ($Region = 'All' AND generic_region_name IS NULL) OR
    ($Region != 'All' AND generic_region_name IN ($Region))
  )
group by netype;

The issue is that generic_region_name contains some NULL values, however Grafana detects NULL values as ‘’ instead of NULL. When I select all regions, I would like for NULL values to be included however I can’t figure out how to ensure Grafana includes these values.

Any help is appreciated. Cheers