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 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. 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

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 a commodity from a drop-down list of values.
Usage	Used to select one or several or all usages.
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.