February 5th to February 9th, 2024
Monday, February 5th, 2024
Attended
- NA
Progress
- Missed meeting will make up on February 6th (Afternoon)
Tuesday, February 6th, 2024
Attended
- Isai
- Brian
Progress
- 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
- Configured tooltips for Tableau
- Configured Brian's access to the github and SCEL ssh
- 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.
- Need Guava data
Wednesday, February 7th, 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
Friday, February 9th, 2024
Attended
- Isai
- Brian
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
- Researched making tutorials for Tableau
- Found video on adding overlays.
Firmware Integration
- NA
External Hours
Attended
- Brian
Progress
- Retrieved waveform data
- Looked into hooking up meters to SCEL database
- Not possible to be automated without some human oversight (at least at the moment)
- 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”
- 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
- NA
Authors
Contributing authors:
Created by bkim on 2024/02/06 20:35.