[Grafana] [InfluxDB] Difference resultset in Previous week vs timerange filter

Grafana InfluxDB
1

Hi,
I find a different result set when using “previous week” vs timefilter. The dashboard is set to UTC and the data is written in UTC format to influxdb.
not sure what mistake I am doing. please find attached screen shots and also the respective query from query inspector.

previous week :
q:“SELECT mean(“UpOrDown”) FROM /xxxxxxxxxxxxxxxxxxxxxxxxxx/ WHERE time >= 1531593000000ms and time <= 1532197799999ms GROUP BY time(1d) fill(null)”
1531593000 = Sun Jul 15 00:00:00 DST 2018
1532197799 = Sat Jul 21 23:59:59 DST 2018

Timefilter
q:“SELECT mean(“UpOrDown”) FROM /xxxxxxxxxxxxxxxxxxxxxxxxxx/ WHERE time >= 1531612800000ms and time <= 1532131199999ms GROUP BY time(1d) fill(null)”
1531612800 = Sun Jul 15 05:30:00 DST 2018
1532131199 = Sat Jul 21 05:29:59 DST 2018

grafana_week
grafana_week1850×794 186 KB
grafana_timefilter
grafana_timefilter1849×772 171 KB
We are using Grafana v5.2.1 (commit: 2040f61) version

Regards,
Bala.

2

This seems like a bug. It uses local browser time for absolute dates. Would suggest you to open a bug report here.

3

Thanks for clarifying, created https://github.com/grafana/grafana/issues/12817 for further tracking