Hi,
Tricky bar chart wanted.
InfluxDB table has fields and data example as follows:
time battery liters seconds signal
---- ------- ------ ------- ------
1564952275000000000 0.5 12
1564952396000000000 3.6 44
1564952457000000000 3.7 0.6 10 54
I managed to get 2 separated queries to retrieve ‘seconds’ and ‘liters’ from the DB.
"SELECT mean("seconds") FROM "shiber" WHERE time >= 1564952400000ms and time <= 1565038799999ms GROUP BY time(10s) fill(null);SELECT mean("liters") FROM "shiber" WHERE time >= 1564952400000ms and time <= 1565038799999ms GROUP BY time(10s) fill(null)"
The graph looks like bunch of thin hairs.
I wanted to set a width to every bar by ‘seconds’ of each record from the DB and height of the bar by ‘liters’.
Is that possible?
Thank you.