select mean(value) from MEDIDOR where time > now()/d group by time(1h)
select mean(value) from MEDIDOR where time > now(d) group by time(1h)
select mean(value) from MEDIDOR where time > $now/d group by time(1h)
select mean(value) from MEDIDOR where time > $now(d) group by time(1h)
select mean(value) from MEDIDOR where time > ${now/d} group by time(1h)
select mean(value) from MEDIDOR where time > ${now(d)} group by time(1h)
Perhaps I have misunderstood your question, but shouldn’t you write your InfluxQL query to use $timeFilter in the WHERE clause of the query so that it references the time selector, and then use Grafana’s dropdown for “Today so far”? In my screenshot below, I did this at 20:30:
now/d is not a macro, so it won’t be interpolated.
I would say the only way is to create dashboard variable which will calculate that value somehow, e. g. mysql/postgresql query and then use that variable in the influxql query.
The only solution I found was to create a python script to do the calculation. Then I inserted it into an Influx database. I don’t know if it’s the best solution, but it works