# Energy usage one day

**URL:** <https://community.influxdata.com/t/energy-usage-one-day/7113>\
**Category:** Systems\
**Tags:** grafana\
**Created:** [October 21, 2018, 8:19am UTC](https://community.influxdata.com/t/energy-usage-one-day/7113 "2018-10-21T08:19:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![piacco](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@piacco](https://community.influxdata.com/u/piacco)\
**Post date:** [October 21, 2018, 8:19am UTC](https://community.influxdata.com/t/energy-usage-one-day/7113/1 "2018-10-21T08:19:41Z")

</div>

I’am just a beginner. I have settup Domoticz to read my energy usage whit the p1 port of my smart-meter. This data is send to influxdb. With Grafana i would like to see the daily consumption. For usage-2 i got the right value (usage 2 is between 7am - 23pm), for usage-1 is the value not right (usage-1 is between 23 pm - 7am). I tink this has something to do with the time.

I looks like

 ![afbeelding](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/e/ef36f05c8e45da8d5057ee135108f89820978f34.png)

I would be great if someone could help me to fix this. 😀

---

<div class="post-metadata">

**Author:** ![piacco](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@piacco](https://community.influxdata.com/u/piacco)\
**Post date:** [October 23, 2018, 8:32pm UTC](https://community.influxdata.com/t/energy-usage-one-day/7113/2 "2018-10-23T20:32:52Z")

</div>

I’ve found a solution when i GROUP BY time(1d, -2h) the values are right.  
But is there also a solution like GROUP BY time(1d), TZ(“Europe/Amsterdam”)