Send a chart sensor in Telegram

Hello,

There’re a lot of posts regarding this topic but I never find a complete solution.
In order to improve my energy consommation knowledge, I would like to receive every morning a line chart (or a bar chart) with the energy consumption. I already have this informations in a sensor.

Here is the list of where I have this metrics on my HA configuration :

  • Stored in a sensor
  • Display with an apexcharts-card
  • Display in Energy Dashboard
  • Display in Grafana Dashboard
  • Hosted in InfluxDB

As you can see a lot of possible display and it’s very interesting but I need to connect to be able to analyze. I whish to add my current possibilities with a recap received by Telegram. This Telegram message must contain an image representing the evolution.

Do you have a solution for this need ?

Haven’t tried it myself but a quick search of “node red data to chart to image” gave me this:
Generate chart images in Node-Red for email or chat messages (flow) - Node-RED (nodered.org)

Yes I found it but I was unable to install the Nore Red module. There is a workarround documented here : [SOLVED] Using node-red-contrib-chart-image - #6 by dceejay - General - Node-RED Forum

But It was too complex for me to launch this command on my installation (see below). I’m not so familiar with shell command and even more with the Docker.

System Information

version core-2022.8.3
installation_type Home Assistant OS
dev false
hassio true
docker true
user root
virtualenv false
python_version 3.10.5
os_name Linux
os_version 5.15.61-v8
arch aarch64
timezone Europe/Paris
config_dir /config
Home Assistant Community Store
GitHub API ok
GitHub Content ok
GitHub Web ok
GitHub API Calls Remaining 4996
Installed Version 1.27.2
Stage running
Available Repositories 1131
Downloaded Repositories 27
Home Assistant Cloud
logged_in false
can_reach_cert_server ok
can_reach_cloud_auth ok
can_reach_cloud ok
Home Assistant Supervisor
host_os Home Assistant OS 9.0
update_channel stable
supervisor_version supervisor-2022.10.0
agent_version 1.3.0
docker_version 20.10.17
disk_total 457.7 GB
disk_used 18.5 GB
healthy true
supported true
board rpi4-64
supervisor_api ok
version_api ok
installed_addons File editor (5.4.1), Samba share (10.0.0), Duck DNS (1.15.0), Grafana (8.0.2), InfluxDB (4.5.0), Node-RED (13.4.0), Mosquitto broker (6.1.3), SSH & Web Terminal (12.0.2), Z-Wave JS (0.1.74), Studio Code Server (5.4.0), Zigbee2MQTT (1.28.0-1)
Dashboards
dashboards 5
resources 21
views 38
mode storage
Recorder
oldest_recorder_run October 8, 2022 at 3:26 PM
current_recorder_run October 11, 2022 at 5:44 PM
estimated_db_size 2173.28 MiB
database_engine sqlite
database_version 3.38.5

Hello,

Nobody has a idea ? I’m pretty sure that some geeks have already a solution for that.