Set query interval to a specific period

I’m a newbie, so sorry for a silly question.

I’m trying to create a panel showing current month daily download data total with data coming from OPNSense with data coming from Telegraf into Influxdb and presented on Grafana.

This is the query I got so far. SELECT non_negative_derivative(last(“bytes_recv”)) FROM “net” WHERE (“interface” = ‘igb0’) AND time >= (now() - 30d ) GROUP BY time(1d)

It works if I set the time range for anything bigger than a day, if lower i present no data.

My goal is to have this panel to get the current month and another panel to get day so far, no matter what is set on the general time range.

What am I doing wrong ?


Any ideas on how to accomplish it ?