i4connected Knowledgebase

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_chart.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 organise 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_button.jpg

    The Calendar button

    • The Time range options - 1H (last hour), 8H (last 8 hours), 1T (last day), 1W (last week), 1M (last month), 3M (last 3 months) 6M (last 6 months) and 1Y (last year).

    • From / To selectors - allow a customised time frame selection, where the user can chose 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, one hour, one day, one month and one year) or can set the option on 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.

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

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

    Media_and_KPI_button.jpg

    The Media and KPIs selectors

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

    Unit_message.jpg

    More than two different units have been selected

  • 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 medias/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 medias/KPIs represented on the right unit axis between lines or bars.

      Important

      This setting is available only if medias/KPIs with two different 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 or stacked representation. When stacking is selected, the medias/KPIs with the same unit are added together, thus displaying the total measurements of that type. The color coding of the different stacked medias/KPIs helps differentiating them.

    • Min/Avg/Max - allows the user to enable chart lines that display the minimum, average or maximum differences (delta) between measurements for each media/KPI.

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

    • Data labels - allow 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).

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

  • 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_button.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, medias/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.

chart_view.jpg

The main Load Profile chart

The main chart supports a maximum of two vertical axes (left and right). The two vertical axes (unit axes) can display two 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 a KPI with a different measurement unit is selected from the media selection options.

second_axisg

The second unit axis

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.

chart_tooltip.jpg

The Chart tooltip

The chart legend displays the selected medias/KPIs of the chart. While hovering the mouse cursor over a legend label, the line trend corresponding to that media/KPI will be emphasised 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.

Capture19.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 is 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 medias/KPIs displayed in the chart, over the complete time range.

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

tables_view.jpg

The aggregated values in table view mode