Workplace Connectors data summarization
Execute the DataSummarization scheduled job to retrieve the daily aggregate summary data. When the scheduled job runs, it collects the data from the target table and MetricBase and stores the daily aggregate data into the respective summary table.
The MetricBase application stores time series data, which is data that is sampled at regular intervals. The administrator specifies a metric to store and how often to collect it by creating a time-series definition in MetricBase. The time-series data is sent from instance to the MetricBase server using the MetricBase API. For more information about MetricBase, see Defining and collecting MetricBase data.
Workplace Connectors supports retrieving the time series data from the MetricBase and populates the data into the following summary tables:
Navigate to to view the summary tables.
| Table Name | Description |
|---|---|
| Space Occupancy Daily Summary Data | The Space Occupancy Daily Summary Data (sn_wsd_wc_space_occupancy_daily_summary_data) table displays aggregate data retrieved from the Occupancy and Environment Data target table and MetricBase. The DataSummarization scheduled job runs daily and loads the daily aggregate summary data into the table. It collects the metric data (Space Occupancy Value) from the target table (Occupancy and Environment data) and MetricBase and populates the data in the summary table (Space Occupancy Daily Summary Data). |
| Wi-Fi Daily Summary Data | In the Wi-Fi Daily Summary Data table (sn_wsd_wc_wifi_daily_summary_data), you can view aggregate data from Wi-Fi providers to determine employee attendance in the office. The DataSummarization scheduled job runs daily and retrieves the summary data based on the Wi-Fi time-series data stored in the Wi-Fi Data target table and MetricBase database. |
| Environmental Daily Summary Data | The Environmental Daily Summary Data table (sn_wsd_wc_environmental_daily_summary_data) displays daily aggregate environment data, including air quality and temperature for a workplace. The DataSummarization scheduled job runs daily and loads the daily aggregate summary data into the Environmental Daily Summary Data table. It collects metric data from the target table (Occupancy and Environment data) and MetricBase and populates the summary table data. |
| Environmental Hourly Summary Data | The Environmental Daily Summary Data table (sn_wsd_wc_environmental_hourly_summary_data) displays hourly aggregate environment data, including air quality and temperature data for a workplace. The DataSummarization scheduled job runs daily and loads the hourly aggregate summary data into the Environmental Hourly Summary Data table. It collects metric data from the target table (Occupancy and Environment data) and MetricBase and populates the summary table data. |