Differences
This shows you the differences between two versions of the page.
| 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=== | ||