api.php giving weird numbers for dns_queries_today

I'm seeing some weird numbers from api.php. I've written a quick script to grab the value for the field dns_queries_today. And then created a chart of those numbers.

What I'm seeing in my chart, is that every hour or so there's a drop in queries. Am I misunderstanding what the dns_queries_today field is representing? I expected this to be a value that would increase over the day, and then reset at midnight.

I've attached a screenshot of what my chart looks like.

Pi-hole is using a one-day rolling time frame, i.e. you are seeing the values for the last 24 hours, not a calendar day.

That still doesn’t explain the huge drop every half hour.

Please post a screen capture of your admin dashboard showing the 24 hour graphs.

Here you go.

The graph looks very normal.

Is it possible to get a count that just counts up from midnight?

You can get this count from the long term database. Select "Today" as the date range.

Can you point me to where that is?