I'm trying to create a timechart at intervals of one month however the below code produces the sum of the entire month, I want the value on the 1st of each month, please let me know any solutions to get value any alternate to span to get intervals as on
2022-10-01 2022-09-01 2022-08-01
`source=all_month.csv place=*alaska* mag>=3.5 | timechart span=mon@mon1 count BY mag`
(index="sales") | fillnull value="undefined"| bucket _time span=mon@mon1 | chart count by _time stock
... View more