Grafana + MariaDB

[Udo_Hartmann]

You have to change the Alias:

@toddwevans

AND… I really wish I understood how openhab creates the tablenames in its DB…

This should be the same name as the item name (you can setup an alias in the *.persist file)

[toddwevans (Todd Evans)]

Sounds easy enough… thanks.
I’ll have to look up how to “syntax” the .persist file.
Thanks again… this has been bugging me for a few months now… didn’t have the time to pursue.

[toddwevans (Todd Evans)]

No joy…
I do not see the option “Alias” in my Grafana instance. What am I missing?

[toddwevans (Todd Evans)]

Well this has been a waste of 2 hours trying to figure out WHY I don’t have the “Alias” option in my Metrics.
v 5.1.4
It’s enough to start looking for another graphing solution

[wars (Ward)]

@michikrug

SELECT FLOOR(UNIX_TIMESTAMP(time)) as time_sec, value, ‘Your custom metric name’ as metric FROM your_sql_column_name WHERE $__timeFilter(time) ORDER BY time ASC;

See some post above, I had the same issue:

Grafana + MariaDB

Sure thing: SELECT FLOOR(UNIX_TIMESTAMP(time)) as time_sec, value, 'Your custom metric name' as metric FROM your_sql_column_name WHERE $__timeFilter(time) ORDER BY time ASC;

[toddwevans (Todd Evans)]

YAY… Thanks, Ward and michikrug!!
Todd

[Udo_Hartmann]

Sorry, didn’t realize you are using SQL as Source.

But happy that @wars could help