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