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

[Dalesh]

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

[Anaisdg]

Hello your InfluxQL query would look something like

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

[Dalesh]

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