Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
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 Overlays to Tableau homepage | ||
| - Added help tooltip ?-Mark to every page on the Tableau Dashboard | - 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=== | ===Attended=== | ||
| * Isai | * Isai | ||
| * Brian | * Brian | ||
| + | ===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 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=== | ===Firmware Integration=== | ||
| Line 77: | 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 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=== | ===Firmware Integration=== | ||