Scatter Graph - filter X value out

[luissimoes]

Hi
I'm sure it is possible, but I didn't manage to make it work.

I have a scatter graph, and want that the X-AXIS only has a point where Y >0....
As I have the X Scale is weekly

My code (I want to control all the car charges where the energy charged is > 9 kWh, because I have a "stupid" wall box :-) )

thank You!

type: custom:plotly-graph
entities:
  - entity: sensor.from_netz_daily
    texttemplate: "%{x}<br>%{y:.2f}"
    textposition: top center
    textfont:
      size: 15
    name: car charges
    type: scatter
    mode: markers+text+lines
    statistic: state
    period: day
    line:
      width: 1
      dash: 3px
      shape: vhv
      color: "#C8CCCC"
    marker:
      color: "#FF5733"
      opacity: 1
      size: 15
      symbol: 215
      line:
        width: 1
        color: "#000000"
    filters:
      - filter: y > 9
layout:
  barmode: scatter
  paper_bgcolor: rgba(0,0,0,0)
  plot_bgcolor: rgba(0,0,0,0)
  margin:
    t: 25
    l: 15
  height: 450
  legend:
    "y": -0.25
    x: 0.15
  yaxis:
    visible: false
    title:
      font:
        size: 9
      text: total energy
  xaxis:
    fixedrange: false
    gridcolor: rgba(238,235,235,0.2)
    showgrid: false
    linecolor: null
    tickformat: "%d %b"
hours_to_show: 6w
refresh_interval: auto
title: 🚙 Car charges (> 9 kwh)
card_mod:
  style: |
    ha-card {
       font-size: 18px !important;
        --secondary-text-color: '#000000';
        border-width: 0px;
        padding-top: 30px
       }
view_layout:
  grid-area: view4

[dbuezas]

I'm not quite sure what you are after. Maybe you can make a picture?

[luissimoes]

Hi David,
thanks. Here it is. As mentioned in the X-Axis I have a week ... but the car charges are "sparse". I want to have an X-point only when Y>9 KwH

[dbuezas]

You mean `mode: markers?

[luissimoes]

?... sorry not sure what you mean :-(...
I mean in the x-axis I wanted to have entries on

• 19 April, 29 April, 7th May (its where the 30.16 kWh is), 11 May and 16 May

instead of weekly i.e 20 April, 27 April 4 May etc....

[dbuezas]

Oh tick text is what you are after

[luissimoes]

yep... actually the *ticks themselves (and per impact the text).
I just want to have ticks when Y>9 kWh, which is what is displayed
filters:
- filter: y > 9

so: only ticks for thes values.... (to compress the graph and make it easier to know when I charged

[dbuezas]

Then you'll have to store the entity data in a var (see store_var), and then use a $ex in the layout/xaxis/ticks