Greetings. I’m trying to graph the counts of (traffic) reports over time.
It was more challenging than I expected, and in case it helps anyone, this is the Flux query that works
from(bucket: "my_bucket") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "traffic") |> filter(fn: (r) => r["_field"] == "value") |> window(every: 1h) |> count() |> duplicate(column: "_stop", as: "_time") |> window(every: inf) |> yield(name: "count")
The results (there’s inbound and outbound) do plot ok as a line graph, but actually a bar chart (with in and out being side-by-side vertical bars) would be much better. (It’s what the customer wants!)
Looking around the influx site, it appears that Influx 1.8’s Chronograf supported bar charts, but 2.0 doesn’t. Is this correct?
Will bar charts be available in InfluxDB2’s dashboard? When? (Sure, Histogram exists, but it’s not “the right data”. In my case, histogram divides into bins of various speed values, but my x axis should be Count, not speed-range-bins.)
Admittedly I installed Influx2 a few months ago (2.0.6), so if barcharts are already available, my apologies and I’ll update. (Bar charts are not mentioned in the documentation, so I don’t think they’re available yet)