Apexcharts: Set data_generator to only import specific hours

[airman84]

Hi guys,

does anyone have any idea, how to set the Apexcharts data_generator to import only hours -2h until +32h?
I know, I can adjust the graph_span and offset, which shows me the data I want, but unfortuntely the scaling in Apexcharts is wrong then.

Here the y-axis is up to 32cent, while the max shown data value is just 26cent. Thats becaue there is data close to 32cent in the data generator, that is filtered out by the graph_span and offset but still affecting the max displayed value on y-axis. By limiting the data_importer to just import the timeframe I want to display, this could be worked around.

Current:

Wanted:

data_generator: >
return entity.attributes.data.map((entry, index) => { return [new
Date(entry.start_time).getTime(), entry.price_ct_per_kwh]; });

Thank you
Oliver

[deltamelter]

Not sure exactly what you mean by only importing -2h until +32h
You can use a filtermap to limit the data displayed, but graph_span and offset are the best way limit the x-axis displayed
If the y-axis doesn't play along, use the max property under yaxis

graph_span: 48h
span:
  start: hour
  offset: '-10h'

yaxis:
  - id: gb30
    decimals: 3
    apex_config:
      tickAmount: 20
    max: '|+5|'
    min: 0

This takes data all the way to the top but adds a 5 unit gap

[airman84]

The EPEX Net price sensor contains here 48h of data. The y-axis is from 12-27cent, which fits to the displayed data.

    graph_span: 48h
    span:
      start: day

But when changing the values like below, as I am not so interested in the past prices, y-axis does not change, to fit the changed interval of data displayed. I would expect now to change the y-avis to 15-27cent, but it remains with 12-27cent, due to the lowest value of 12,9cent, which is loaded via the data_generator, but not displayed anymore. Min/Max values of apexcharts, seem to belong to Min/Max of available data, but not of displayed data. So my approach would have been, to configure the data_generator, to import the same hours I want to display, so the Min/Max values will fit.

    graph_span: 34h
    span:
      start: hour
      offset: '-2hr'

[deltamelter]

then use filtermap. It will then only hold the window of data that you are interested in.

[deltamelter]

[airman84]

Hi,
many thanks for your reply. I would be happy to try it, but the code is cut on the right side. Could you maybe post the code here?
Thank you

[airman84]

I just noticed, that I made a mistake when configuring the yaxis in apexcharts... everything works as expected, no need for a changed data_generator. sorry for wasting your time :(