1 year history graph grouped by month

[miguelfreitaspt]

Hello.

I wanted to create a consumption graph that had the monthly consumptions, i.e. grouped by month, over a year.
Is this possible? Thanks.

[altserg]

Try my config sample. I do not like the X axis formatting (prefer that all 12 months are listed there), but I do not know how to do that.

type: custom:apexcharts-card
locale: en
hours_12: false
apex_config:
tooltip:
x:
format: MMM yyyy
header:
show: true
title: Yearly Water Consumption
show_states: true
colorize_states: true
graph_span: 1year
span:
start: year
series:

• entity: sensor.montly_water_consumption
  type: column
  color: cyan
  show:
  in_header: false
  statistics:
  type: state
  period: month
  align: start
• entity: sensor.yearly_water_consumption
  type: column
  show:
  in_chart: false

[pLeXwithFleX]

Hey guys,

im trying the same with a custom state measurement entity wthich count our laundry. My problem is when I set "type to state" under the statistics series no value is available and wont show. If I remove this setting, it shows me correctly the last value of the month, but not the current value during the month:

here is my code:

type: custom:apexcharts-card
apex_config:
  chart:
    height: 300px
experimental:
  color_threshold: true
graph_span: 1year
locale: de
span:
  start: year
show:
  last_updated: false
header:
  show: true
  show_states: true
  colorize_states: true
  title: Statistik
  floating: false
now:
  show: true
  label: heute
  color: red
yaxis:
  - min: 0
    max: ~15
    decimals: 0
    apex_config:
      tickAmount: 5
series:
  - entity: sensor.custom_wasche_counter
    show:
      header_color_threshold: true
      extremas: true
    type: column
    name: Wäsche
    statistics:
      period: month
      align: start
      type: state
  - entity: sensor.custom_trockner_counter
    show:
      header_color_threshold: true
      extremas: true
    type: column
    name: Trockner
    statistics:
      period: month
      align: start
      type: state

The entity looks good to me:

I want to display the sum of the previous months and also the current value of the current month until the end.
Can anyone assist?

thx alot

Alex