# Query for show values from day before / Grafana

**URL:** https://community.influxdata.com/t/query-for-show-values-from-day-before-grafana/23734
**Category:** Grafana
**Tags:** influxdb, grafana, influxql, query
**Created:** [February 7, 2022, 12:26pm UTC](https://community.influxdata.com/t/query-for-show-values-from-day-before-grafana/23734 "2022-02-07T12:26:58Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![nils50122](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/nils50122/32/9427_2.png) [@nils50122](https://community.influxdata.com/u/nils50122)
#### Post date: [February 7, 2022, 12:26pm UTC](https://community.influxdata.com/t/query-for-show-values-from-day-before-grafana/23734/1 "2022-02-07T12:26:58Z")

</div>

Hello,

i search the whole day for about options to show two values (the same value in db) in one grafana dashboard.  
The query `"SELECT mean("value") FROM "Kesseltemperatur" WHERE $timeFilter GROUP BY time($__interval) fill(previous)"` will display the value on actual graph with selected timerange in grafana.  
For example when i select an timerange from “last 6 hours” the query is:  
`SELECT mean("value") FROM "Kesseltemperatur" WHERE time >= now() - 6h and time <= now() GROUP BY time(10s) fill(previous)`

Now i need to display the same value from the day before (-24h) in the same graph.  
Is there something like a query:  
`SELECT mean("value") FROM "Kesseltemperatur" WHERE time >= now(-24h) - 6h and time <= now(-24h) GROUP BY time(10s) fill(previous)`

I read much about timeshift and so one, but i dont want to upgrade to influx 2.0 to get timeshift feature. I use influx 1.8.9 and grafana v8.1.1.