Threshold color change based on free Ram i.e. multiple machines in one panel

Hi all,

I have made a panel to monitor the ram available on our windows machines

ram

This is done via a InfluxDB_telegraph query. What i want is that the color of the panel turns red when reaching a threshold based on the total available ram on a machine but i cannot figure this out how to do this in just one panel with multiple machines with different amounts of ram in them.

This is the query i use now:

`Object

request:Object

method:“GET”

url:“api/datasources/proxy/5/query”

params:Object

db:“telegraf”

q:“SELECT max(“Available_Bytes”) FROM “win_mem” WHERE time >= now() - 5m and time <= now() GROUP BY time(500ms), “host” fill(none)”

epoch:“ms”

data:null

precision:“ms”

hideFromInspector:false

response:Object

results:Array[1]

0:Object
`