I want to visualize data from clickhouse in graph with 1M step, but Grafana groups the data in a strange way. The earliest date in the DB is 1 of May, but with 1M step Grafana creates April column. This strange separation affects all the other column making their stats wrong. The same problem with 1w step. The smallest step that allow to visualize data correctly is 1d. So how to make 1M grouping without data distortion?
Same here any thoughts??