#Any way to do opower AND IotaWatt in the energy panel?

1 messages · Page 1 of 1 (latest)

mellow heart
#

So I have opower setup that gets official energy cost and usage from my electrical company, which is nice. It also provides (mostly) accurate historical data. I like this, I think that's good.
I also got an iotawatt because... Well my electricity usage was too high and I wanted to learn why.
(turns out, having the fan always on on a gas furnace is dumb)
Now that I've had the data for a few days, and my electric company stopped having issues, I have overlapping data periods.
Personally, I feel like a stock feature for "this is my bill and not a second power usage" makes sense in home assistant. But honestly I'm happy to just make a template or something that would use the iotawatt data until opower populate and then use that data instead.
Is there some way to do this? I'm struggling to even figure out how to phrase it for googling, but I haven't found an answer.

jagged brook
#

You're trying to merge old data with new data?

#

Or what exactly is the goal

mellow heart
#

Whoops I wasn't notified.
Yeah a template entity that had the opower data and overwrote the iotawatt data every day would work. But the goal is to show both sets.

jagged brook
#

There's no template that can overwrite data

mellow heart
#

Hmm. So there's no way to have both data streams in the energy panel without them getting added together?

jagged brook
#

If you check here Q1 there's something about transferring statistics

jagged brook
mellow heart
# jagged brook No, what would that look like?

Few ideas. But. Mark one as "authoritative" since it's from the power company. Just shows next to the other source and is expected to be equal to the total of all non-authoritative sources.
If I saw they were different I'd have to check that out.

#

Or just drop the data from the less important one off the chart when the authoritative one populates for that time period, since it actually has price information.

jagged brook
#

Oh. There's no such thing. Grid sensors are expected to sum up to your total consumption

mellow heart
#

Yeah. But in this case that's not quite what I want.

jagged brook
#

But you can make a graph for it yourself

mellow heart
#

What kind of graph is the calendar thing? Can I make one of those?

#

Actually, looking at how that's integrated with the page, probably not? I'd be happy to make a second energy page for the other values though.

jagged brook
#

Calendar thing?

#

You can only have one energy dashboard

#

If you want some more freedom have a look at apex charts

#

You can make any chart you can think of

mellow heart
#

The ability to change time scale easily in reference to the bar chart.

jagged brook
#

That's a particular feature of the energy dashboard

mellow heart
#

Apex charts actually will be helpful I'm going to install this.

jagged brook
#

It can do a lot of stuff

mellow heart
#

Yeah that's definitely something I'll look into tomorrow. That could bridge the gap.
Thanks!

jagged brook
#

There are some examples for energy data in this channel

surreal rover
#

In my case I have the opower statistics in the energy dashboard and I have a separate dashboard with various cards of type statistics-graph

#

e.g.

#
chart_type: line
period: hour
type: statistics-graph
entities:
  - opower:pge_elec_XXX_energy_consumption
  - sensor.consumption_minus_production_energy
stat_types:
  - change
days_to_show: 4
title: Hourly consumption minus production