So I have a D3 Gauge panel, that I’m trying to display the full output in bits/sec for our LAN. I am getting this info using telegraf and the info is in InfluxDB The info is there but it does not display correctly.
The issue is the data comes from influx like so:
First is the time, second is the bits per sec. I want the guage to be displayed as Mbps, so when I select Units->data rate->bits/sec the main value is correct eg. 219Mbps but I believe the gauge is still being displayed as bits/sec
Do I need to do some math to the query?
Here is currently:
SELECT derivative(mean(“ifHCOutOctets”), 1s) *8 AS “Output” FROM “autogen”.“interface” WHERE (“hostname” = ‘XXXXXXXXXXX’ AND “ifDescr” = ‘LAN’) AND time >= now() - 6h GROUP BY time(30s), “ifDescr”