This page allows you to view the monthly analytics data collected for each equipment action in a dynamic pivot table format. A chart of the selected data in the pivot table can also be viewed.
For details about this component and pivot grid fundamentals, please review this section: https://docs.devexpress.com/WindowsForms/1794/controls-and-libraries/pivot-grid/fundamentals
The default view shows rows for the year - month - group - equipment. For each row, the summary column data is shown for baseline occupied hrs, calculated occupancy hrs, avoided occupancy hrs, and the avg % avoided hrs.
You can move data fields between the row header area, data header area, and filter header area to change how your pivot table summarizes the data. Each data field can be filtered to show selected data.
The fields for “Avoided Hrs” and “Avg % Avoided” are calculated in the pivot table and will show zero (0) whenever the “Baseline Occupied Hrs” are also zero (0).
Note: If you don’t have baseline schedules defined for your equipment zones, then baseline hours will be zero.
Show Data
This button will present the raw data in a table format for the selected items in the pivot table.
Print Preview
This will present a preview of the page prior to printing or exporting the data. You may need to scale the page to fit it on one page.
Export
This will export the pivot table to excel.
Reset Layout
This will reset the pivot table back to the initial default layout. If you change the columns or filters in the pivot table, those changes will be saved (per user) when the page is closed so it is restored next time you open it.