Grafana

[benji.aaron]

Hello,

Since Hubitat has grown so much and i can now view some key data for my home (Emporia & PTLevel) i would like to utilize Grafana.
Currently i have everything setup via cloud services. if i can get it running proper and reliably i will move it to a local headless Pi.

Currently i have been able to link influx through the InfluxDB Logger to Grafana.
i can view some data in a Grafana dashboard but selecting "temperature" for instance just brings in all my temp sensors and labels them all "Value."
Now, the values are correct but my device names are not showing and i cant seem to find a way for them to show.
just as well i cant seem to find a way to only, for conversation, show two of the three sensors.
I know theres a small Grafana community on here, just hoping i can figure this out.

C8 Pro
Grafana
InfluxDB Cloud V3 Serverless
SQL Query Language

[thebearmay]

Need to modify your Select for the graph.

SELECT ts2 AS "time", ts_value AS "C8 Pro" FROM hubistats.temperature_Pro

[benji.aaron]

What language is that using?
SQL, InfluxQL, or Flux?

im extremely green to coding.

[thebearmay]

That's the SQL that the graph in Grafana is using to pull information from the database.

[benji.aaron]

Using Explore in Grafana it returned:
flightsql: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: table 'public.hubistats.temperature_pro' not found

[thebearmay]

Table name should match the table that is being used to capture your data.

[thebearmay]

@jtp10181 and @mavrrick58 have several threads on here that you may find useful

[jtp10181]

I have these pre built dashboards but they are coded in Flux from Influx v2, I think they totally dropped support for Flux in v3 I heard?

Ready-to-Use Grafana Dashboards! - Beta Test / Feedback

Working on building these to share, to work in conjunction with the InfluxDB Logger app. InfluxDB2 (Flux) Required by default, some are ported to work on 1.x (InfluxQL). Data Source for Flux must be setup in Grafana using Query Language: Flux Easy drop down menus at the top to configure for your setup. Support for alternate device name Tags if you are not using InfluxDB Logger. Supports multiple hubs being fed to same bucket. Download info at bottom of post How to import a dashboard: Manag…

[benji.aaron]

that's what I'm under the impression of as well.
it looks the SQL is they way of the future but I'm not seeing it, lol.

There has to be a way for more visibility in how InfluDB is taking from Hubitat and sending to Grafana. feels like im in the dark on that.

Setting up a Plex Servarr has been easier then figuring this out.

[mavrrick58]

Is the new version of influxdb avaliable yet for home use. My understanding was that influxdb v3.x was a cloud only thing.

Honestly bringing sql to influxdb is exciting for me. I have been dealing with DB's that use SQL for query for about 20 years. It isnt hard once you get use to it.

On another note if using docker for influxDB on Feb 3 it appears installs using :latest will start getting 3-core.

[benji.aaron]

if i can make this a dependable dashboard tool i do plan to use docker.
currently im using DBs cloud offering to test viability.
not looking great so far.

My place of work uses Grafana, im hoping to learn it to help my career as well.
always easier to learn when its something for yourself, then apply it for a paycheck.

[mavrrick58]

It is very dependable once setup. Take a look at the thread that @jtp10181 linked above to see several of his dashboards. The problem you are having is you are on influxdb3.

I will try to remeber tomorrow to install the 3-core instance on one of my servers and start to test it. It doesn't look like there is a direct upgrade path fron the older versions.

Here is another thread in the subject.

Using HE with with InfluxDB, Grafana, with InfluxDB Logger

For right now this will just be a consolidation of all of the help topics I have provided to others or has been provided to me. I will clean this up to where it flows better in abit. Introduction to the InfluxDB, Grafana, InfluxDB Logger Stack We have the great home automation systems that generate a ton of actions off of events that occur around our home. These events are datapoints we may want to be able to see on occasion. By using the InfluxDB as a backend database to store our data, Graf…

[benji.aaron]

Awesome. I will do some reading tonight and research SQL coding.
I would greatly appreciate anything you can come up with if you're able to do some testing yourself.
Im sure it will help the community as well, as people continue to adopt Grafana.

[sburke781]

SQL is my day-job as I expect it may be for others here.... happy (willing) to help where I can. Influx is less native for me... Python will need to become more familiar...

[thebearmay]

@sburke781

SQL is my day-job

Was mine for a while ~30 years ago...

[mavrrick58]

Quick question what options did you use for InfluxDB Logger to work with InfluxDB 3.x. I didn't know it was updated to work with it.

[benji.aaron]

I didnt do anything special. I dropped my influx cloud url, port 443, and API token.
Booted up Grafana and was able to pull data from influx bucket.
I dont really know how the information is being sent/recieved but seeing data means somethings working, i assume.

[benji.aaron]

Does influxdb cloud V3 differ from local influxdb V3?

[jtp10181]

I thought I saw on the main thread for the Influx Logger a while back where someone tested it and said it worked. I would guess you set it up with a v2 connection.

[mavrrick58]

Yea.. it does appear the lable in the logger app has also been updated to say v2/v3 now.. that is awesome to see