Monthly aggregate next to each other (per year)

[grant2]

@kasyx

Data label is showing first day of a month instead of previous

Are you just wanting to correct the fact that your graph shows 2 blocks for the month 09-2024? Try playing with the AggregateWindow statement to include a start or stop.

Also try specifying the stop time in the range function with this:

date.truncate() function | Flux Documentation

@kasyx

I would like to see months next to each other between the years. Meaning August’23 should be next to August’'24 but with dufferen colour. Doable?

Sort of…See this thread:

Comparing different years in one graph from one data source

Hello is it possible to display in one graph (x-axis from 1. Jan to 31. Dec) several years. My data source is a mysql database but I was not able to querry values only for 2021 and another query for 2020 etc. thanks