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

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

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

We are using Grafana v5.2.1 (commit: 2040f61) version


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

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