# Struggling with query from 1.8 to v2 in Grafana

**URL:** <https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683>\
**Category:** InfluxDB 2\
**Tags:** grafana\
**Created:** [April 30, 2021, 5:49pm UTC](https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683 "2021-04-30T17:49:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bmenard](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@bmenard](https://community.influxdata.com/u/bmenard)\
**Post date:** [April 30, 2021, 5:49pm UTC](https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683/1 "2021-04-30T17:49:02Z")

</div>

Hi,  
How do i query :

SELECT spread(“Value”) FROM “471200\_STEM\_AHU01” WHERE (“Units” = ‘kWh’ AND “Name” = ‘AV\_1002\_STEM\_AHU01\_SF1\_ELEC\_CONS\_KWH\_AV’) AND time \>= now() - 24h GROUP BY time(1h), “Name”

from influx 1.8 in v2. I can’t get the value to spread every 1h. Can’t figure out how to make the GROUP BY time(1h) function in v2.

So far, this is what i ended up with:

from(bucket: “048\_STEM”)

|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r["\_measurement"] == “471200\_STEM\_AHU01”)  
|\> filter(fn: (r) =\> r[“Units”] == “kWh”)  
|\> filter(fn: (r) =\> r[“Name”] == “AV\_1002\_STEM\_AHU01\_SF1\_ELEC\_CONS\_KWH\_AV”)  
|\> filter(fn: (r) =\> r["\_field"] == “Value”)  
|\> spread()

Thx in advance!

---

<div class="post-metadata">

**Author:** ![scott](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/scott/32/16492_2.png) [@scott](https://community.influxdata.com/u/scott)\
**Post date:** [April 30, 2021, 10:36pm UTC](https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683/2 "2021-04-30T22:36:27Z")

</div>

@bmenard This should get you what you need:

```auto
from(bucket: "example-bucket")
  |> range(start: -24h)
  |> filter(fn: (r) =>
    r._measurement == "471200_STEM_AHU01" and
    r._field == "Value" and
    r.Units == "kWh" and
    r.Name == "AV_1002_STEM_AHU01_SF1_ELEC_CONS_KWH_AV"
  )
  |> aggregateWindow(every: 1h, fn: spread)

```

---

<div class="post-metadata">

**Author:** ![bmenard](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@bmenard](https://community.influxdata.com/u/bmenard)\
**Post date:** [April 30, 2021, 11:01pm UTC](https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683/3 "2021-04-30T23:01:37Z")

</div>

Thx! You made my weekend!

Man do i love Influxdb and his community!

Have a good weekend my friend!

---

<div class="post-metadata">

**Author:** ![scott](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/scott/32/16492_2.png) [@scott](https://community.influxdata.com/u/scott)\
**Post date:** [May 1, 2021, 1:33am UTC](https://community.influxdata.com/t/struggling-with-query-from-1-8-to-v2-in-grafana/19683/4 "2021-05-01T01:33:03Z")

</div>

Happy to help! Have a great weekend!