Ploting Graphs using Grafana

Configuration
1

Hi,
Just installed Grafana, managed to create a connection to my MariaDB, but I am not aware of the schema of HA.
Do you have some example queries maybe I take an idea?

TIA

2

There is an example in this;

3

looking good :slight_smile:
tomorrow will take a look and will let you know!

4

apprently the scheme for influxdb is different from that of mysql :frowning:

5

So set up influxDB?

6

i think schema is the same :slight_smile:
but for some reason each entry in the event is being shown as a data series. do you know how I can go around it?

image
image1653×710 64.3 KB

7

decided to go to InfluxDB …are you aware of any good updated guide?

8

Hi, are you using Hass.io? If you are, I’ve had good experience using the two add-ons (Grafana and InfluxDB). Installation/config guides are linked from each add-on’s info page. The two make a good combination!

9

Yes I am using hassio, currently saving into a mysql dB (Mariadb). I followed the config you suggested, but the influxdb was not being updated although in the history page in hassio was being updated. Most probably data was being written in the sqllite db

10

Should I remove recorder section and put the entities under influxdb?

11

With MariaDB addon you can use this approach (requires a cast)

grafana_plot
grafana_plot2728×1298 328 KB

1 Like
12

how do i change the name of the thing from value_ i change it in the query but if i change it anything else than value or value_ it says error and stops displaying anything

13

i figured it out

SELECT
  last_updated AS "time",
  cast(state as float) as "test2"
FROM states
WHERE
  $__timeFilter(last_updated)
and
  entity_id = 'sensor.inverter_power'
ORDER BY last_updated
2 Likes