Differences

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

--- weatherbox:dashboard_v5:week_4_-_2024 [2024/02/13 20:13]
bkim
+++ weatherbox:dashboard_v5:week_4_-_2024 [2024/02/16 22:15] (current)
bkim
@@ Line 9: / Line 9: @@
   - Added Overlays to Tableau homepage
   - Added help tooltip ?-Mark to every page on the Tableau Dashboard
-  - Added a Monthly Average
+  - Added a Monthly Average Irradiance to Guava and Apple on Grafana Dashboard.
+===Dashboard Versioning===
+Tableau Dashboard (Isai) -> Dashboard V5
+Grafana Dashboard (Brian) -> Dashboard V7
 ----
-====Tuesday, February 6th, 2024====
+====Tuesday, February 13th, 2024====
 ===Attended===
   * Isai
   * Brian
+===Attended===
 __**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
   - 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
-  - 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===
-  - Need to find common hours to work on Grafana.
+  - Got Guava data
-  - Need Guava data
 ----
-====Wednesday, February 7th, 2024====
+====Wednesday, February 14th, 2024====
 ===Attended===
-  * Isai
   * 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
-  * Brian
 __**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===
-  * Isai
+  * Isai (in person)
-  * Brian
+  * Brian (online, sick)
 __**Progress**__
-  - Added Guava to the Dashboard and improved the SQL queries. Changed 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===
@@ Line 77: / Line 68: @@
 ===Attended===
   * Brian
+  * Isai
 __**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 a 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===