MeterFactMonthly

Purpose: Tracking utility consumption per building per month. Includes tables and charts for comparing meters and tracking data. Each meter has up to 3 values per QuantityID: handread data, a rollup value which is the summation of 15 minute interval values, and a totalizer value which is a meter's totalizer channel using end of month minus beginning of month. These exist for auditability and to eliminate under-reporting if interval values report as NULL. A QC tab exists for energy specialist/technician to check current month values against historical data and averages, and a AUX billing tab provides values for meters currently billed by Tawnee to Auxiliary units for easy data transfer to her billing spreadsheet. This will need to evolve as billing processes change.

Link: https://fs-tableau.uoregon.edu/#/workbooks/25/views

End User: Energy Team

Date Created: 4/15/2020

Created By: Alex Koleber

Approved By: Justin Porter

Notes: Will continue to improve this report

Platform: Tableau

Data Source: Data Warehouse; Utility_History

Change Log