I have a query to my (postgres) database in which I can receive status for some of my systems for a certain time interval. I can get a table like this:
site | ok | warning | critical
-------+------+---------+----------
arb2 | 0.00 | 0.00 | 1.00
hfa2 | 0.00 | 0.00 | 1.00
nc204 | 0.00 | 0.00 | 1.00
nc205 | 0.00 | 0.00 | 1.00
nra2 | 0.00 | 0.00 | 1.00
nc202 | 0.00 | 0.33 | 0.67
and so on…
I would like to show this as a horizontal stacked bar graph - if that is possible. I have found and installed the multistat plugin and I can make a horizontal bar graph of either of my parameters (ok, warning, critical) but can I get a stacked graph?
This is a quick and dirty example of what I want made in Excel (although Excel for some reason turns my data set upside down, I want the rows with the highest values for “critical” plotted on the top as my query returns it)
