Table of Contents
February 5th to February 9th, 2024
Monday, February 5th, 2024
Tuesday, February 6th, 2024
Wednesday, February 7th, 2024
Thursday, February 8th, 2024
Friday, February 9th, 2024
External Hours
Authors
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:
bkim
ifoglesong
Created by
bkim
on 2024/02/06 20:35.