Grouping data with slightly different timestamp

Grafana InfluxDB
1

Hi, I’m using Grafana v10.2.3 on Raspbian. I’m collecting monthly sums from various energy counters in an InfluxDB. These values should be grouped by month, but it seems that timestamps differ by milliseconds, so these are considered separate points in time:

image
image1545×629 25.4 KB

The three bars on the left are from January first while the three (or rather four) on the right are from February first:

Any idea how I can make Grafana neglect those milliseconds? I read about plugins like groupedbarchart, but was unable to install and I’m unsure if they’re still valid for recent Grafana versions.

2

Check this out

data
    |> truncateTimeColumn(unit: 1m)
3

Pretty sure that @luas is using InfluxQL.

Grouping by month is not possible using InfluxQL. More in the final table of this blog.

4

Sorry for being unprecise there. I can’t even tell… but this is what my query looks like:

image
image887×386 30.9 KB

@grant2 Regarding your blog, wouldn’t it be sufficient to group by day? There are only datapoints for January 1st, February 1st and so on.

5

Sure. In fact, if you follow one of the links in the blogs, you can see a bunch of InfluxQL queries, including one that sums Demand by day:

SELECT sum("value") FROM "ElectricPowerOperations" WHERE ("type"::tag = 'Demand' AND "region"::tag =~ /^$region$/) AND $timeFilter GROUP BY region, time(1d)

image
image1537×721 65.3 KB

6

Thanks @grant2 !
It turns out that grouping by day leaves me with a lot of empty days…

image
image1498×788 52.3 KB

…while grouping by 30 days feels a bit dirty, but brings up what I was hoping for. So what :smile:

image
image1491×736 48.2 KB

Thank you!

7

Scary to realize flux will be in maintenance mode and move to influxql with no matching powerful functions in influxql

Maybe they are working on it