weatherbox:dashboard_v5:week_4_-_2024

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
weatherbox:dashboard_v5:week_4_-_2024 [2024/02/13 20:16]
bkim
weatherbox:dashboard_v5:week_4_-_2024 [2024/02/16 22:15] (current)
bkim
Line 11: Line 11:
   - Added a Monthly Average Irradiance to Guava and Apple on Grafana Dashboard.   - Added a Monthly Average Irradiance to Guava and Apple on Grafana Dashboard.
  
-==Dashboard Versioning== +===Dashboard Versioning=== 
-Tableau Dashboard (Isai) ​--> Dashboard V5 +Tableau Dashboard (Isai) -> Dashboard V5 
-Grana Dashboard (Brian) ​--> Dashboard V7+ 
 +Grafana ​Dashboard (Brian) -> Dashboard V7
  
  
 ---- ----
  
-====Tuesday,​ February ​6th, 2024====+====Tuesday,​ February ​13th, 2024====
 ===Attended=== ===Attended===
   * Isai   * Isai
   * Brian   * Brian
-  * +
 ===Attended=== ===Attended===
 __**Progress**__ __**Progress**__
-  - Looked into self hosting Grafana. It is possible, but will require collaboration with Firmware +  - Finished adding Guava data and diagnostics to Dashboard V7 
-    - Kenny already made Grafana self hosted +    - Added Library Panels to streamline future additions
-  - Bounded Grafana SQL queries  +
-    - Fixed time_received sort order+
   - Updated wiki   - Updated wiki
   - Configured tooltips for Tableau   - Configured tooltips for Tableau
 +    - Added in graphics and started adding overlays to other pages
   - 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. +  - Got Guava data
-  - Need Guava data+
  
 ---- ----
  
-====Wednesday,​ February ​7th, 2024====+====Wednesday,​ February ​14th, 2024====
 ===Attended=== ===Attended===
-  * Isai 
   * Brian   * Brian
- 
-__**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 
----- 
- 
-====Thursday,​ February 8th, 2024==== 
-===Attended=== 
   * Isai   * Isai
-  * Brian 
  
 __**Progress**__ __**Progress**__
-  - tbd+  - Added more overlays to weather data, pressure, and temperature in Tableau 
 +  - Made major edits to the Grafana dashboard for clarity (staggered transparent and opaque backgrounds).
  
 ---- ----
  
-====Friday, February ​9th, 2024====+====Friday, February ​16th, 2024====
 ===Attended=== ===Attended===
-  * Isai +  * Isai (in person) 
-  * Brian+  * Brian (online, sick)
  
 __**Progress**__ __**Progress**__
-  - Added Guava to the Dashboard ​and improved ​the SQL queriesChanged the appearance of some of the visualizations ​to make the graphs ​more intuitive +  - Dashboard ​v7.0: Realized that all the data was plotted backwards, made the appropriate edits. 
-  - Researched making tutorials for Tableau +    - Made the temperature ​visualizations more intuitive ​and user friendly ​ 
-    - Found video on adding overlays.+  - Finally squared away Brian'​s ssh connection!
  
 ===Firmware Integration=== ===Firmware Integration===
Line 83: Line 68:
 ===Attended=== ===Attended===
   * Brian   * Brian
 +  * Isai
  
 __**Progress**__ __**Progress**__
-  - Retrieved waveform data +  - Figured out what the heck happened ​to the Tableau data 
-  - Looked into hooking up meters to SCEL database +    - Make sure data is in EXTRACT FORM 
-    - Not possible ​to be automated without some human oversight (at least at the moment) +  - The SSH error was solved ​by converting the private key into putty key file
-    - Live power consumption ​data looks implausible for now. +    Still don't know how to get the commandline ssh running.
-  - 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_4_-_2024.1707855386.txt.gz
  • Last modified: 2024/02/13 20:16
  • by bkim