weatherbox:dashboard_v5:week_4_-_2024

This is an old revision of the document!


February 12th to February 16th, 2024

Attended

  • Brian
  • Isai

Progress

  1. Added Overlays to Tableau homepage
  2. Added help tooltip ?-Mark to every page on the Tableau Dashboard
  3. Added a Monthly Average

Attended

  • Isai
  • Brian

Progress

  1. Looked into self hosting Grafana. It is possible, but will require collaboration with Firmware
    1. Kenny already made Grafana self hosted
  2. Bounded Grafana SQL queries
    1. Fixed time_received sort order
  3. Updated wiki
  4. Configured tooltips for Tableau
  5. Configured Brian's access to the github and SCEL ssh FIXME
  6. Can make stat graph showing day-on-day/month-on-month by making an SQL query.
    1. Done! The little number below the Irradiance measure shows % change since last month

Firmware Integration

  1. Need to find common hours to work on Grafana.
  2. Need Guava data

Attended

  • Isai
  • Brian

Progress

  1. Added Tool Tips to Tableau, for brief explanation on how to use the maps.
  2. Attempted to put Grafana on the Tableau as a URL input, encountered error, gonna try to fix Public version URL
  3. Found out from Firmware that Guava Data is embedded into apple data. We plan on separating by Node Address in SQL
  4. Talked to firmware to try and diagnose the issue with apple's humidity reading
  5. Updated Wiki

—-

Attended

  • Isai
  • Brian

Progress

  1. tbd

Attended

  • Isai
  • Brian

Progress

  1. Added Guava to the Dashboard and improved the SQL queries. Changed the appearance of some of the visualizations to make the graphs more intuitive
  2. Researched making tutorials for Tableau
    1. Found video on adding overlays.

Firmware Integration

  1. NA

Attended

  • Brian

Progress

  1. Retrieved waveform data
  2. Looked into hooking up meters to SCEL database
    1. Not possible to be automated without some human oversight (at least at the moment)
    2. Live power consumption data looks implausible for now.
  3. Spoke to Kenny about the SQL server, SCEL database, possible FTP server, and moving the SCEL database over to “ITS-land”
  4. Discovered that Apple's temperature was off by a scale factor of about 0.06701030927 or Local Temp/Measured Temp
  5. Skimmed strange Humidity readings from Dashboard

Firmware Integration

  1. NA

  • weatherbox/dashboard_v5/week_4_-_2024.1707855186.txt.gz
  • Last modified: 2024/02/13 20:13
  • by bkim