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 data sampling is activated. For more information, see Data Sampling.

You can view data trends in two ways:

Device view provides a device centric view. It displays data from a selection of devices for a specified period of time and compares data within an equivalent period of time.
Aggregated view provides a data centric view. It displays aggregated data of energy consumption based on a commodity and/or usage, without reference to specific devices.

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 differ from the raw data values in the CSV file exported to your PC .

The type of trending graph displayed depends on the type of data selected. There are two types of graph:

Bar chart: used to display integrated data (for example, energy, reactive energy) or aggregated data
Line graph: used to display continuous data (for example, temperature, apparent energy)

The type of graph is indicated by an icon next to each type of data in the Data drop down menu. The types of data available in the list depend on the device selected.

A legend below the graph indicates device and data type per curve. A tooltip pops up when hovering the cursor over the graphs, indicating date, time, device name, value and unit for each data plot.

NOTE: A maximum of 16 curves can be displayed on a line graph.

Availability

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

Aggregation Principle

The trending figures in Aggregated view are the result of an aggregation algorithm used to calculate the consumption of energy. Only Active energy is calculated.

In order to aggregate the consumed energy of the loads, all usages are considered in the aggregation except:

Main/Incomer
Sub/Head of group
Total

Any device configured with one of these usages is not displayed in Aggregated view or in the Home page.

Data Trending Device View Settings

To customize data displayed in Device view:

Select the device(s) you want to view.
Select the data you want to view. Only two different types of data can be displayed together.
Activate compare mode by clicking the slider icon if you want to compare periods.
Select the period of time you want to display.

The following table describes the settings.

Parameter	Description
Devices	Used to select one or several devices.
Data	Used to select the data to be used for the graph. For different types of data with continuous measurements (for example, voltage and current).
Compare mode	Disable to get the graph on a single period. Enable to get comparing data from two periods of same duration.
Period	When the parameter Compare mode is enabled, used to select the period duration (One day, One week, 4 weeks).
From	When the parameter Compare mode is disabled, used to select the period start date. 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 for each period: Select the current period (Period 1) start date. Select the previous period (Period 2) start date. 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
To	When the parameter Compare mode is disabled, used to select the period end date. NOTE: The default end date is today (D). NOTE: When the parameter Compare mode is enabled, the end date is defined automatically according to the selected start date and period.
Interval	When the parameter Compare mode is disabled, used to select the interval of data displayed by hour (H), day (D), or Month. NOTE: Week is only applicable for integrated data, fro example, to display Energy consumption over a period of month displayed as energy consumed by day.
Clear filters	Used to erase any selection of devices, data or periods of time previously selected.

Data Trending Aggregated View Settings

To customize data displayed in Aggregated view:

Select the commodity you want to view. Only one commodity can be selected.
Select the usage(s) you want to view.
Activate compare mode by clicking the slider icon if you want to compare periods.
NOTE: When compare mode is activated, a maximum of 16 usages can be displayed.
Select the period of time you want to display.

The following table describes the settings.

Parameter	Description
Commodity	Used to select one or several commodities from a drop-down list of values.
Usage	Used to select one or several or all usages.
Compare mode	Disable to get the graph on a single period. Enable to get comparing data from two periods of same duration.
Period	When the parameter Compare mode is enabled, used to select the period duration (One day, One week, 4 weeks).
From	When the parameter Compare mode is disabled, used to select the period start date. 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 for each period:. Select the current period (Period 1) start date. Select the previous period (Period 2) start date. 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
To	When the parameter Compare mode is disabled, used to select the period end date. NOTE: The default end date is today (D). NOTE: When the parameter Compare mode is enabled, the end date is defined automatically according to the selected start date and period.
Interval	When the parameter Compare mode is disabled, used to select the interval of data displayed by hour (H), day (D), or Month. NOTE: Week is only applicable for integrated data, for example, to display Energy consumption over a period of month displayed as energy consumed by day.
Clear filters	Used to erase any selection of devices, data or periods of time previously selected.