- Posted on
Thu Feb 08, 2018 10:18 am
-
siclark
offline
-
- Posts: 1961
- Joined: Jun 13, 2017
- Location: UK
Yes, agree would need some updating and refreshing but manageable on adhoc basis if I saw issues on the results.
I am trying to setup a dashboard for my house in Qlikview which has free personal license for single use, and is a data visualisation tool I have used for many years, and can read data from postgresql.
With a table of all device ids I can create a loop to load in each table, and with the names against them, create a more useful name for that device. I have done this manually copying out from the log the list of all devices, but a pain to update this way.
Taking it to the next step, I can then create a different sql statement per device type, ie per PIR, thermostat, light switch etc, where each type has the same columns. As I loop through the device ids, if the name ends "PIR", or "Stat" etc (I am consistent with my naming of devices) then it will load that device into the right table.
I can then create interactive charts there .