ApexChart Monthly Data

Configuration Frontend
1

I want to display monthly energy with the cost. Now is september but why the bar in the card stored on 31 Aug?

image
image910×722 34.2 KB

type: custom:apexcharts-card
graph_span: 3month
span:
  end: month
header:
  show: true
  title: Cost & kWh Last 30 days
yaxis:
  - id: first
    decimals: 0
    apex_config:
      tickAmount: 5
    min: 0
    max: 200000
  - id: second
    opposite: true
    decimals: 0
    apex_config:
      tickAmount: 5
    min: 0
    max: 100
all_series_config:
  stroke_width: 2
  type: column
series:
  - entity: input_text.monthly_kwh
    yaxis_id: first
    show:
      header_color_threshold: true
      extremas: true
    type: column
    color: green
    name: Rp
    group_by:
      func: last
      duration: 1month
  - entity: sensor.utility_energy_monthly
    yaxis_id: second
    color: red
    show:
      header_color_threshold: true
      extremas: true
    type: column
    name: KwH
    group_by:
      func: last
      duration: 1month
2

The database only stores 10 days of state data by default.

Use the statistics option in ApexCharts to access long term statistics data exceeding 10 days.

3

If add statistic then the graph always loading

image
image964×692 13.4 KB

  - entity: sensor.utility_energy_monthly
    yaxis_id: second
    color: red
    show:
      header_color_threshold: true
      extremas: true
    type: column
    name: KwH
    statistics:
      period: month
    group_by:
      func: last
      duration: 1month
4

Try hourly or daily.