weatherbox:dashboard_v5:week_3_-_2024

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
weatherbox:dashboard_v5:week_3_-_2024 [2024/02/06 20:35]
bkim created
weatherbox:dashboard_v5:week_3_-_2024 [2024/02/13 20:08] (current)
bkim [Friday, February 9th, 2024]
Line 17: Line 17:
 __**Progress**__ __**Progress**__
   - Looked into self hosting Grafana. It is possible, but will require collaboration with Firmware   - Looked into self hosting Grafana. It is possible, but will require collaboration with Firmware
 +    - Kenny already made Grafana self hosted
 +  - Bounded Grafana SQL queries ​
 +    - Fixed time_received sort order
   - Updated wiki   - Updated wiki
 +  - Configured tooltips for Tableau
   - Configured Brian'​s access to the github and SCEL ssh FIXME   - Configured Brian'​s access to the github and SCEL ssh FIXME
 +  - Can make stat graph showing day-on-day/​month-on-month by making an SQL query.
 +    - Done! The little number below the Irradiance measure shows % change since last month
  
 ===Firmware Integration=== ===Firmware Integration===
   - Need to find common hours to work on Grafana.   - Need to find common hours to work on Grafana.
 +  - Need Guava data
  
 ---- ----
Line 31: Line 38:
  
 __**Progress**__ __**Progress**__
-  -  +  - Added Tool Tips to Tableau, for brief explanation on how to use the maps. 
 +  - Attempted to put Grafana on the Tableau as a URL input, encountered error, gonna try to fix Public version URL 
 +  - Found out from Firmware that Guava Data is embedded into apple data. We plan on separating by Node Address in SQL 
 +  - Talked to firmware to try and diagnose the issue with apple'​s humidity reading  
 +  - Updated Wiki
 ---- ----
  
Line 51: Line 61:
  
 __**Progress**__ __**Progress**__
-  - tbd+  - Added Guava to the Dashboard and improved the SQL queries. Changed the appearance of some of the visualizations to make the graphs more intuitive 
 +  - Researched making tutorials for Tableau 
 +    - Found video on adding overlays.
  
 ===Firmware Integration=== ===Firmware Integration===
-  - tbd+  - NA
  
 ---- ----
Line 69: Line 81:
     - Live power consumption data looks implausible for now.     - Live power consumption data looks implausible for now.
   - Spoke to Kenny about the SQL server, SCEL database, possible FTP server, and moving the SCEL database over to "​ITS-land"​   - Spoke to Kenny about the SQL server, SCEL database, possible FTP server, and moving the SCEL database over to "​ITS-land"​
 +  - Discovered that Apple'​s temperature was off by a scale factor of about 0.06701030927 or Local Temp/​Measured Temp
 +  - Skimmed strange Humidity readings from Dashboard
  
 ===Firmware Integration=== ===Firmware Integration===
  • weatherbox/dashboard_v5/week_3_-_2024.1707251735.txt.gz
  • Last modified: 2024/02/06 20:35
  • by bkim