How show future values?

Energy
1

Hello,

I have a sensor in which I have stored energy prices for today and tomorrow. I know them in advance. The data is also in the influx database.
I can't create a graph in either influx or grafana that would display future values. I would like a graph where I can see 96 + 96 values ​​(including future ones). The X axis would be fixed so that it doesn't react to changes when the range changes.

Can you advise me?
Thank you
Pavel

2

Are you having problems plotting this, or just getting the future data loaded in the first place?

3

good day,

the data in the database is. it is stored with future times and dates. I don't know how to display it in influx explorer or in grafana. Everyone if about the display ends with the current date and time.

Ideally as a bar graph with a fixed X axis.

Pavel

4

You can use an apex card for that, I use it to indicate a threshold (which is used as trigger to start charging my car)

image
image475×377 14 KB

type: custom:apexcharts-card
grid_options:
  columns: full
graph_span: 24h
span:
  start: hour
  offset: "-3h"
now:
  show: true
  label: Now
header:
  show: true
  show_states: true
  colorize_states: true
apex_config:
  yaxis:
    min: 0
    max: 0.5
    tickAmount: 10
    decimalsInFloat: 2
series:
  - entity: sensor.frank_energie_prices_current_electricity_price_all_in
    name: Price
    show:
      in_header: raw
      legend_value: false
    stroke_width: 5
    float_precision: 3
    type: column
    opacity: 0.3
    color: "#03b2cb"
    data_generator: |
      return entity.attributes.prices.map((record, index) => {
        return [record.from, record.price];
      });
  - entity: input_number.ev_charge_price_threshold
    name: EV Threshold
    color: "#FF0000"
    stroke_width: 2
    stroke_dash: 4
    show:
      in_header: false
      legend_value: false
    type: line
    extend_to: end