On Wednesday, October 5, 2016 at 7:10:12 PM UTC+5:30, [email protected] wrote: > Op woensdag 5 oktober 2016 12:59:32 UTC+2 schreef [email protected]: > > Hi Team, > > > > I am creating the Disk I/O graph using Grafana and InfluxDB as Data Source. > > I am using the below query from Grafana to get both Read_Bytes and > > Write_Bytes for particular host. > > > > SELECT mean("read_bytes") AS "Read_Bytes", mean("write_bytes") AS > > "Write_Bytes" FROM "diskio" WHERE "host" =~ /^$hostname$/ AND $timeFilter > > GROUP BY time($interval) fill(null) > > > > I am getting two horizantal lines in graph for both fields and not getting > > the correct graph. When I select single field in query the graph is coming > > correct. Please let me know what changes needs to be done to get correct > > Disk I/O graph. > > > > Thanks and Regards, > > Sree > > > Try this: > > SELECT mean("read_bytes") AS "Read Bytes", mean("write_bytes") AS "Write > Bytes" FROM "diskio" WHERE "host" =~ /^$Hostname$/ AND $timeFilter GROUP BY > time($interval), "host" fill(null)
Hi, I am getting the same issue after updating the query as you mentioned. Here I have selected one host only. The Y-axis values changes automatically depending on fields selected (Read/write). Does the The Y-axis readings should be same for both fields (Read./write) Thanks and REgards, Sree -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/26990c82-0d69-4c48-a5e9-9360188868fb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
