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 ?


Hello @Andre_Martins,
Welcome! At what interval are you writing data to InfluxDB? =
Thank you :slight_smile:

Every 5 seconds it receives the data.

Hi @Anaisdg

Any idea how to set a fix period ?

Hello @Andre_Martins,
What do you mean by set a fix period? Can you verify that you have multiple data points within a day? If you do you should be able to groupby at subdaily intervals. What version of InfluxDB are you using? If you’re upgraded to 1.8+ and this problem persists, can you please submit an issue?
Thank you!