SQL - all instances health indicator - Zabbix datasource

So maybe I’m barking up the wrong tree here, but I thought I’d reach out and see if someone has a solution.

I’ve seen it done via InfluxDB, but i’m using the Zabbix datasource along with some SQL templates/scripts, to collect data from each of our SQL servers.

I want to create a farm overview board, showing, amongst other things, a simple health indicator.

Based on the standard SQL status codes, which rage from 0-42, I want it to say ‘Healthy’, ‘Degraded’ or ‘Critical’.

I can present this data in a table (image attached), but I can’t for the life of me work out how to get it into a single/blendstat-type widget.

Is it even possible, or do I need to sanitise the data further, prior to it hitting Grafana?

My idea with this board, is that when a new SQL server is added to the Zabbix group (and polled), it will automatically add the overview data to Grafana.

My Host, Application and Item queries are;

/SQL Instance MSSQLSERVER Database .*: Status/

Thanks a bunch!