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=== |