i4connected Knowledgebase 5.6

Load Profile

Abstract

The Load Profile charts multiple measurements of preselected objects using a complex representation, over custom time ranges.

This article describes the Load Profile panel from the i4connected portal.

The Load Profile panel illustrates measurements for two or more different objects (areas, organizational units, or counters) using a complex chart representation. It provides comprehensive settings for displaying the data, such as predefined and custom time ranges, resolution, and KPI selection, based on the available data in the selected objects.

Load_Profile.jpg

The Load Profile chart

The Load Profile chart represents the data obtained from an intersection between the chosen objects, the selected time range, and the available KPIs. The data obtained from this intersection is referred to as data series.

The user can interact with the Load Profile dashboard and organize the following settings:

  • selection of the Time frame by clicking on the Calendar button - the view is expanded to display the following time frame options:

    Calendar_Load_profile.jpg

    The Calendar button

    • The Time range selectors allow the user to select predefined time ranges that start from the current date and time. The available predefined options are:

      • 1H - one-hour time range, going back from the current time

      • 8H - eight hours time range, going back from the current time

      • 1T - one-day time range, going back from the current date (previous day)

      • 1W - one-week time range, going back from the current date (previous week)

      • 1M - one-month time range, going back from the current date (previous month)

      • 3M - three months time range, going back from the current date

      • 6M - six months time range, going back from the current date

      • 1Y - one-year time range, going back from the current date (previous year)

    • From / To selectors allow a customized time frame selection, where the user can choose the Start and End date and time.

    • Resolution selectors allow the user to select the resolution of the data rendered in the chart (the time interval between two consecutive measurements displayed on the time axis). The user can choose between five predefined resolutions (15 minutes, hourly, daily, weekly, monthly , and yearly) or can set the resolution to Auto.

      When the Resolution is set to Auto, the system automatically adjusts the resolution based on the active Time range setting and the current zoom level.

      Note

      Since version 5.6.15, the Load Profile dashboard supports up to 18.000 data points that cover the following resolutions:

      • 2 series of hourly data over one year / 6 months (if more than 2 series are added, the hourly resolution is disabled)

      • 2 series of 15-minute data over 3 months (if more than 2 series are added, the 15min resolution is disabled)

      For low resolution, such as hourly per 1 year, it is recommended to use the lines as display mode because bars dramatically increase the performance.

    After selecting the desired time frame, the user must click on the Apply button to preserve the selected timeframe.

  • selection of the Media and KPIs - the list of all Media and KPIs is displayed, allowing the user to select one or multiple entities.

    In order to be represented on the Load Profile chart, the data series must have a maximum of four different measurement units. A notification message is provided for the user, as soon as more than four units are selected.

    Max_KPIs.jpg

    The Media and KPIs selectors

  • selection of the Chart settings opens the section that allows the user to configure how the data series are represented in the chart.

    Chart_settings.jpg

    The Chart settings selectors

    Using the Y-Axis settings-Left, the user can configure the following options:

    • Left [unit] - toggles the charts mode for the media/KPIs represented on the left unit axis between lines or bars.

    Using the Y-Axis settings-Right the user can configure the following options:

    • Right [unit] - toggles the charts mode for the media/KPIs represented on the right unit axis between lines or bars.

      Important

      This setting is available only if media/KPIs with multiple units are selected for display.

    The other charts settings allow the user to configure the following options:

    • Stacking - allows the user to toggle between normal Normal.jpg or stacked Stacked.jpg representation.

      When stacking is selected, the media/KPIs with the same unit are added together, thus displaying the total measurements of that type. The color-coding of the different stacked media/KPIs helps to differentiate them.

      Chart_with_stacked_respresentation.jpg

      Example of a chart with stacked representation

    • Min/Avg/Max/Agg - allows the user to enable chart lines that display the minimum, average and/or maximum differences (delta) between measurements for each media/KPI. Additionally, the user can also enable the representation of the measurements aggregation.

      Min_Avg_Max_Agg.jpg

      Example of a chart with Min/Avg/Max/Agg representation

    • Gaps - allows the user to toggle on or off the gaps display.

      Gaps.jpg

      Example of a chart with Gaps representation

    • Data labels - allows the user to toggle on or off the labels that indicate the delta and measurement values at a measurement point in the charts (the displayed measurement points depend on the selected resolution).

      Data_labels.jpg

      Example of a chart with Data labels representation

    • Show parents - allows the user to toggle on or off the display of the origin of the selected media/KPIs. The parents will be displayed by the chart's legend.

      Show_parents.jpg
  • exporting the data to Excel format by clicking the Export button. It allows the user to export the data that is currently displayed by the chart to an XLSX Format. The exported data can be viewed using Microsoft Excel (or any other spreadsheet software that supports the XLSX format).

    XLS_export.jpg

    The Excel export button

  • selection of the Object filters - the most important component of the data series, is given by the objects to be compared. By clicking the Open Filter toolbar button, the Object Filter panel is opened. In this view, the user can select two entities that will be compared.

    Open_filter.jpg

    The Open filter button

    Tip

    For more details regarding the Object Filter, please also visit our article here.

The central view of the Load Profile panel is the main chart. This is where the data series are displayed based on the selected objects, media/KPIs, and time options. Each measured Object entity will be represented in the chart with a different color, which makes the chart easier to read even if it is measuring multiple Objects.

The_chart.jpg

The main Load Profile chart

The main chart supports a maximum of four vertical axes (two on the left side and two on the right side). The four vertical axes (unit axes) can display four different measurement units, while the horizontal axis (time axis) always displays the time-stamp of the measurement.

The second vertical axis is automatically added when KPIs with a different measurement unit are selected from the media selection options.

Vertical_axes.jpg

The second set of unit axes

By hovering the mouse cursor above the chart, a tooltip is displayed providing the user with information upon the timestamp, the KPI name, and the measurement value.

Tooltip.jpg

The Chart tooltip

The chart legend displays the selected media/KPIs of the chart. While hovering the mouse cursor over a legend label, the line trend corresponding to that media/KPI will be emphasized in the chart by dimming down the other trend lines.

Chart_legend.jpg

The Chart legend

The zoom chart

The zoom chart is displayed at the bottom of the main chart. In this view, the user can narrow down (zoom in) on a specific area of the time range. The zoomed area can be expanded or moved anywhere in the original time interval.

Chart_Zoom.jpg

The zoom chart

The zoom chart shows the overall data trends and helps the user to easily locate a specific section by displaying the general data variation for the whole time range. The main chart's resolution and data are updated for every change in the zoom chart.

When dragging a rectangle on the zoom chart, the selected area becomes highlighted. The zoom manipulation is done using the left and right limit bars. The limit bars can be dragged using the mouse to the desired location within the time range. The zoomed area can also be panned by dragging it using the mouse. The changes in the zoom chart are applied upon clicking the Apply button.

The current position (date and time) of the left and right limit bars is displayed in the labels above the zoom chart.

The aggregated values

The bottom section of the Load Profile panel represents the aggregated values of the media displayed by the chart. This section acts like a summary, stating the total or average measurements for all objects and their media/KPIs displayed in the chart, over the complete time range.

Aggregated_value_cards.jpg

The aggregated values area

The aggregation is done by taking into account the media/KPI type. If the type indicates the addition of measurements, the aggregation will be done by summing up all the measurements of the respective media/KPI. If the type indicates the average of measurements, the aggregation will be done by calculating the average value of all the measurements of the respective media.

The aggregated values can be viewed either in individual tiles (default) or in a table. The two buttons from the top-right corner of the aggregated values area allow the user to switch between tile and table view modes.

Table_viw.jpg

The aggregated values in table view mode