How to make a card with historical PV-Power Data compared to sun rise?

[Micha12323]

Hey-Hoo,

i am looking for a better comparison for my PV-Data. Everyone uses nice graphs but the "real" historical informations are mostly hidden in the data beyond the autoscale...

I was thinking about line drawings on a daily basis normalized to sunrise time. Maybe in a 3d plot?

Correct me, but I haven't found anything into that direction

[fpdragon]

This is what I currently have, not the best but it works.

type: custom:plotly-graph
entities:
  - entity: sensor.sun_elevation
    name: Sun Elevation
    showlegend: false
    line:
      color: rgba(70, 70, 70, 1)
    fillcolor: rgba(70, 70, 70, 0.5)
    fill: tozeroy
    yaxis: "y"
  - entity: sensor.xx_pv_power_gesamt
    name: PV Power gesamt
    showlegend: false
    line:
      color: yellow
    filters:
      - resample: 1m
    fill: tozeroy
    yaxis: y2
  - entity: sensor.xx_pv_overpower
    name: PV Overpower
    showlegend: false
    line:
      color: blueviolet
    filters:
      - resample: 1m
    fill: tozeroy
    yaxis: y2
hours_to_show: 24
refresh_interval: 10
defaults:
  yaxes:
    fixedrange: true
layout:
  height: 150
  yaxis:
    title: ""
    showticklabels: false
    side: left
  yaxis2:
    side: left
    showticklabels: true

And you need to have this template defined:

- sensor:
    #---------------------------------------------------------------------------
    # Sun "{{ state_attr('sun.sun', 'elevation')|float }}"
    - name: "Sun Elevation"
      unique_id: "xx_sun_elevation"
      unit_of_measurement: "°"
      # device_class: "temperature"
      state_class: "measurement"
      state: >
        {% if state_attr('sun.sun', 'elevation')|float > 0.0 %}
          {{ state_attr('sun.sun', 'elevation')|float }}
        {% else %}
          {{ 0.0 }}
        {% endif %}
      icon: "mdi:weather-sunset"

And of course you need to add a sun entity.

Hopefully this helps. Change for Energy and so on.

[Micha12323]

Thank you fpdragon for your answer! :)
I guess I need to learn how to work with the data first. At first I thought I would have to relate the data to the sunrise, but it might be easier once I really get historical data into the plot.
I'm going to do some searching :)

[Micha12323]

Just to summarize my progress: I am experimenting with the offset function. And it looks already really nice. I also added the "Now line" from the readme, which is really nice.
It would be awesome to get the maximum, minimum and median values at each timestamp. But these topics are ideas..
This week i will try some things with the offset, to match it to the sun..

[Micha12323]

Over time, I am pretty happy with that solution. Its just an offset of one day but you can compare a whole week and compare the results. You can see the changed sun elevation time on the left and the right side. Nevertheless it is okay like it is. Like the 80% version of my dreams

[deltamelter]

Not sure exactly what OP is trying to do, but I also put solar output up against sun.elevation and demand and solcast forecast. didn't need to do anything special.
Would like to get the demand/usage on negative side of the axis. Is there a simple way to do that? can you subtract the value from 0 using a filter?