Graphing delta values of mid-month

[thisIsLiving]

I currently have a graph that shows the monthly energy export from a cumulative kWh entity. Code below. How do I modify it so that it calculates the difference between the 15th of each month so that it aligns with my billing?

type: custom:plotly-graph
title: Monthly Export
entities:
  - entity: sensor.goodwe_meter_total_energy_export
    statistic: sum
    period: month
    filters:
      - delta
    type: bar

[dbuezas]

The integrate filter has a reset_every option y can use for that.

So instead of fetching the monthly sum statistic, fetch the daily one and integrate that one with a reset every 1M and an offset of 15 days.

[thisIsLiving]

Sorry I'm not following. The sensor.goodwe_meter_total_energy_export is in kWh already. If I integrate it, it's in kWhd?

type: custom:plotly-graph
title: Monthly Export
entities:
  - entity: sensor.goodwe_meter_total_energy_export #kWh
    statistic: sum
    period: month
    filters:
      - delta
    type: bar
  - entity: sensor.goodwe_meter_total_energy_export
    statistic: sum
    period: day
    filters:
      - integrate:
          unit: d # defaults to h
          reset_every: 1M # Defaults to 0 (never reset). Any duration unit (ms, s, m, h, d, w, M, y).
          offset: 15d
    type: bar
layout:
  barcornerradius: 10
  dragmode: pan
  height: 400
  xaxis:
    rangeselector:
      "y": 1.2
      buttons:
        - count: 1
          step: month
        - count: 3
          step: month
        - count: 6
          step: month
        - count: 12
          step: month
  yaxis:
    tickformat: ",.0f"
    title:
      text: kWh
defaults:
  yaxes:
    fixedrange: true
autorange_after_scroll: true
hours_to_show: 6M

[dbuezas]

Instead of the sum statistic, fetch the median. Otherwise you can also derive, followed by filter: y>=0 (to get rid of the existing resets), followed by integrate