Parse a sensor that already gives a list of (timestamp, values)

[r-jean-pierre]

Dear all,

I was wondering if someone could help me to do something with many of the entities I have.
In general, I have something like this:

This entity sensor.veolia_daily_consumption is in fact giving me a history of 3 months with the same pattern: day, value a hundred of time
With ApexCharts I started to understand the mechanism map((val, index) => {return [new Date(val[0]).getTime(), val[1]]; but how to do it with plotly-graph? I feel it has something to do with filters and fn, but i didn't find an exemple where a value in y will be cast into a date and then fill the x values

[dbuezas]

I think #213 is a good base for this. In this case it should be something like this: (not testee)

 filters:
      - fn: |-
          ({ meta }) => ({
            xs: meta.HistoryConsumption.map(([date, value ]) => new Date(date)),
            ys: meta.HistoryConsumption.map(([date, value ]) => value),
          })

[r-jean-pierre]

Yeaaaaah it works! Many thanks!
Here is a YAML for those who have exactly the same component from veolia water provider:

- type: custom:plotly-graph  # test vdc
    entities:
    - entity: sensor.veolia_daily_consumption
      filters:
        - fn: |-
            ({ meta }) => ({
              xs: meta.historyConsumption.map(([date, value]) => new Date(date)),
              ys: meta.historyConsumption.map(([date, value]) => value)
            })
      show_value: true
    hours_to_show: 2244

And the result:

[dbuezas]

Perfect!
Btw, you can now (v3.2.0) write:
hours_to_show: 10d (10days) instead.

[r-jean-pierre]

Hi!

Here is me again!
I have some cosmetic questions for you :) if you see how to optimize them, it would be wonderful to have some help.
Based on a similar sensor to the previous one, I had to do something again like this:

filters:
  - fn: |-
      ({ meta }) => ({
        xs: meta.dailyweek.map((date) => new Date(date)-3600*1000),
        ys: meta.dailyweek_HP.map((value) => value)
      })

it renders:

Cosmetic1: it would be perfect to see the show_value of the last datapoint, and not the first one:

Cosmetic2: assuming it's not possible because of the filter-fn trick, the legend is still "ugly" because it adds the scatter trace information:

note that other points are okay (including last one):

and for "normal" sensors (i.e. with no need of filters-fn trick ), the last point legend is also totally perfect (but i suppose you knew it already):

Cosmetic3: in plotly doc (https://plotly.com/python/line-charts/) it seems that we can put markers on top of line (e.g: px.line(df, x='year', y='lifeExp', color='country', markers=True) ), could it be possible with the card? I tried to put in the yaml some markers: true everywhere but no success... if possible, it would display that:

Cosmetic2+cosmetic3 (but this question is probably to new): it sounds like you are able to show the last value with the show_value: true so "can we have the min and max value text on top of the curve?" it seems that plotly do not have this option, but they suggest to the users to construct this feature with the add_annotation feature (https://plotly.com/python/text-and-annotations/)
and then, a possible result could be equivalent to:

[dbuezas]

You again! 😆

Those are good requests, would you put them in issues (bug report and feature request) instead?
If they are there I will fix it when I have time, otherwise these get lost inside the discussions. Plus I get to close an issue when I make the release :)