Need To Prepare Query To Calculate FTD,MTD,YTD Values

Hello Support Team,
I am getting data on daily basis . It rest daily two times according to shift wise .I can able to represent data in from on daily basis but I am not able to create graph on monthly basis .because data is reset daily . plz tell me how can I sum all data of one month represent it in monthly wise in graph form.
plz give solution about that.
thankyou

Hello your InfluxQL query would look something like

select sum("myfield") from "mymeasurement" where time > now() and time < -1mo
1 Like

Thank you mam for provide solution but when I am trying to apply query it is showing some error like invalid duration.