Data Trending (Advanced Model)

Presentation

The Panel Server Advanced allows you to display trending graphs based on the logged historical data over a selected time period.

The trending of the logged data on a Panel Server Advanced requires that the measurements to be viewed have been selected for logging, and that data sampling is activated. For more information, see Data Sampling.

You can trace trends of historical data over a single period of time or, using the compare mode, you can compare the same data from two different periods of the same duration (for example, comparing data from the week starting July 10th 2022 to the week starting July 17th 2022).

NOTE: The energy values shown in the trending graphs and exported from the Trending page differ from the raw data values exported in the local export CSV file.

You can view the data in the following ways:

Device view: view trending graphs for a selected device
Aggregated view by usage
Aggregated view by zone

For more information about the Trending page and how to view data, refer to Trending Menu.

For more information about usages and zones, refer to Appendix H: Contextualization Data.

Availability

This function is available on Panel Server Advanced webpages, at Trending.

Aggregation Principle

The trending figures in Aggregated view by usage and Aggregated view by zone are the result of an aggregation algorithm used to calculate the consumption of energy.

For electricity, the aggregation algorithm calculates consumption of active energy in Wh. For other commodities the algorithm calculates consumption by volume in cubic meters (m³).

NOTE: In order to aggregate the consumed energy of the loads, all usages are considered in the aggregated view by usage except:

Main/Incomer
Sub/Head of group
Total

Any device configured with one of these usages is not displayed in aggregated views or in the Home page. You can filter by Main/Incomer in Aggregated view by usage to display the relevant data. Refer to Trending Menu

Data Trending Device View Settings

The following table describes the settings.

Parameter	Description
	Used to select the means to group devices in the list: Usage (default) Zone
Devices	Used to select one or several devices.
Data	Used to select the data to be used for the graph. The types of data available in the list depend on the devices selected.
Compare mode	Disable to display the graph over a single period. Enable to get compared data over two periods of the same duration.
Period	When the parameter Compare mode is enabled, used to select the period duration: One day One week 4 weeks Custom
From	When the parameter Compare mode is disabled, used to select the period start date and time. NOTE: The default period is one day, the start date is yesterday (D-1), and the start time is 12.00 AM. When the parameter Compare mode is enabled, used to select the start date and time for each period: Select the current period (Period 1) start date and time. Select the previous period (Period 2) start date. The time is automatically set at the same time as Period 1. NOTE: The default start date depends on the period selected: One day: Period 1: D-1; Period 2: D-2 One week: Period 1: D-7; Period 2: D-14 4 weeks: Period 1: D-4 weeks; Period 2: D-8 weeks Custom: Period 1: D-1; Period 2: D-2
To	Used to select the period end date and time. NOTE: The default end date is today (D). When the parameter Compare mode is enabled, the end date is defined automatically according to the selected start date and period for fixed time periods (day, week, 4 weeks). For the Custom period, select the end date of the first period. The end date and time of the second period are set automatically to ensure that the two periods are of the same length.
Interval	Used to select the interval of integrated data displayed in bar charts: by hour (H), day (D), or Month. NOTE: Interval is only displayed when the type of data selected is integrated data (displayed with a bar chart icon in the list).
Clear filters	Used to erase any selection of devices, data or periods of time previously selected.

Data Trending Aggregated View Settings

The following table describes the settings.

Parameter	Description
Filter by zone/Filter by usage	Used to select the following filters: Zones to display (when in Aggregated view by usage) Usages to display (when in Aggregated view by zone
Commodity	Used to select a commodity from a drop-down list of values.
Usage (Aggregated view by usage)	Used to select usages: Specific usages All usages Main/Incomer usage Main usages (displays five main usages, and other usages grouped together, based on consumption) Individual usages (one or several) NOTE: For the calculation of main usages: With compare mode disabled, usages are calculated over the period selected (period 1). With compare mode enabled, usages are calculated over the sum of periods 1 and 2.
Zone (Aggregated view by zone)	Used to select zones: Specific zones All zones Main zones (displays five main zones, and other zones grouped together, based on consumption) Individual zones (one or several)
Compare mode	Disable to display the graph over a single period. Enable to get compared data over two periods of the same duration.
Period	When the parameter Compare mode is enabled, used to select the period duration: One day One week 4 weeks Custom
From	When the parameter Compare mode is disabled, used to select the period start date and time. NOTE: The default period is one day and the start date is yesterday (D-1). When the parameter Compare mode is enabled, used to select the start date and time for each period: Select the current period (Period 1) start date and time. Select the previous period (Period 2) start date. The time is automatically set at the same time as Period 1. NOTE: The default start date depends on the period selected: One day: Period 1: D-1; Period 2: D-2 One week: Period 1: D-7; Period 2: D-14 4 weeks: Period 1: D-4 weeks; Period 2: D-8 weeks Custom: Period 1: D-1; Period 2: D-2
To	Used to select the period end date and time. NOTE: The default end date is today (D). For the Custom period, select the end date and time of the first period. The end date and time of the second period are set automatically to ensure that the two periods are of the same length.
Interval	Used to select the interval of data displayed in bar charts: by hour (H), day (D), or Month.
Clear filters	Used to erase any selection of devices, data or periods of time previously selected.
Export	Used to export the data from the current display to a csv file. For more information, refer to Trending Data Export