Analysis of electricity consumption compared with the previous year #334
Replies: 4 comments 8 replies
-
|
Very cool! |
Beta Was this translation helpful? Give feedback.
-
|
Also in using time_offset to make space for the values at the end of the traces: https://github.com/dbuezas/lovelace-plotly-graph-card#show_value |
Beta Was this translation helpful? Give feedback.
-
|
By the way, this is exactly why I created this integration: to maximise customisation to the extent that I am surprised myself of the things people come out with. It makes me very happy seeing it put to good use :) |
Beta Was this translation helpful? Give feedback.
-
|
Hi @dbuezas I'm not a developer, is there a way to create a constant based on the date ? My goal is to calculate the electricity price based on the past dates, I want to setup a constant that will be: 0,147 before 01/02/2023 This constant is the kWh price that I will use to multiply with kWh to get past prices. Any help will be appreciated :-) |
Beta Was this translation helpful? Give feedback.
-
|
You can use a type: custom:plotly-graph
hours_to_show: 1y
entities:
- entity: sensor.the_kwh_sensor
period: day
filters:
- map_y: |
{
let price = 0.147;
if (x>new Date("2023-02-01")) price = 0.161;
if (x>new Date("2023-08-01")) price = 0.1828;
return y * price;
}
For the future, you may want to look into energy price entities, you may even be able to update past prices and then load that as an extra entity, use resample and do the computation by ys index. Congratulations, you are now a developer :) |
Beta Was this translation helpful? Give feedback.
-
|
Hi @dbuezas I'm nearly able to do anything with this card, vey happy about it event if i surely miss a lot of possibilities. Anyway, I would like to create period in years, do you know if it's possible ? Thanks for your help |
Beta Was this translation helpful? Give feedback.
-
|
Oh home assistant supports year for statistics now? |
Beta Was this translation helpful? Give feedback.
-
|
OK, thanks for the update, I was'nt aware it was an Home Assitant limitation. |
Beta Was this translation helpful? Give feedback.
-
|
It's supported by Home Assistant now, just not by this card yet. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you, done: #339 |
Beta Was this translation helpful? Give feedback.
-
|
Interesting this topic, i'm trying to reproduce this on my HA but i don't understand difference between these sensor : And i can use this with my edf tempo setup (so with 6 sensors define in the energy module of HA) ? |
Beta Was this translation helpful? Give feedback.
-
|
Consommation EDF is just the value of the EDF meter (total increasing). This is the sum of EDF Heures Pleines (HP) + EDF Heures Creuses (HC) in my case consommation_journaliere_edf is a derivative of sensor.consommation_edf which is reset everyday at 00:00, it's the electricity consumption of the day, something like that if I remember:
|
Beta Was this translation helpful? Give feedback.
-
For a long time now, I've been looking for a graph that would enable me to analyze my electricity consumption, particularly in relation to the previous year.
Thanks to Plotly, I've been able to produce a graph that, while far from perfect and error-free, for the most part meets this need.
The main information is as follows:
Note: year and year-1 are offset aligned for 364 days to compare a sunday with a sunday, a monday with a monday,
Hourly analysis:
yesterday and today are much higher than last year (yellow bars), previous days were lower.
Daily analysis:
Yearly analysis:
In détail:
Electricity consumption by hour compared to Year-1 (weekdays are aligned, I compare a monday with a monday with a time_offset: +364d
In yellow: this year consumption
In brown:: last year consumption
White line: forecast based on last year consumption
Here temperature (outside in green, inside in red), humidity (blue line) for current year (plain lines) and previous years (dashed lines), rain for this year (blue bars) and hot water consumption (red bars) are added:
Daily consumption:
Yellow means consumption is higer than previous year
As I'm not a developer, this was quite complex to create, mainly copy/paste of existing examples here and there are a lot of small errors , but here is the code:
Beta Was this translation helpful? Give feedback.
All reactions