Hi There,
Is it possible to use variables / SQL Results in a SingleStat Prefix / Postfix?
For example, I have the following query:
(A) SELECT ((last(“raidTotalSize”) - last(“raidFreeSize”)) / (1024 * 1024 * 1024)) AS raidUsedSize FROM “raidTable” WHERE (“agent_host” =~ /^host/) AND timeFilter GROUP BY time(__interval) fill(null)
This query calculates the Used Raid Size (in TB) but, in the SingleStat PostFix / Prefix field for the panel, can I enter a variable value so that the SingleStat panel shows $raidUsedSize / $raidTotalSize (for example: “1TB / 2TB”)?, where $raidTotalSize (2TB in this example) is dynamically returned from the InfluxDB as:
(B) SELECT (last(“raidTotalSize”) / (1024 * 1024 * 1024)) AS raidTotalSize FROM “raidTable” WHERE (“agent_host” =~ /^host/) AND timeFilter GROUP BY time(__interval) fill(null)
I know I could just put the static value for the raidTotalSize in the SingleStat column as, for example by entering the static string " / 2TB" but this means I have to change the PostFix value each time to raid total size grows - Would be much better if I could have this raidTotalSize as dynamic from a database query?
I guess the follow-on question from this is, if the above is possible, is it also possible to specify dynamic values in the threshold fields such as 50% of $raidTotal Size, 90% of $raidTotalSize?
Thanks!