i4connected Knowledgebase 5.6

Delta Analysis

Abstract

The Delta Analysis method compares measurements for either two objects on a defined time interval or for a single object on two equal time intervals.

This article describes the Delta Analysis panels from the i4connected portal.

The Delta Analysis method compares measurements for either two objects (areas, organizational units or counters) on a defined time interval (Object Delta) or for a single object on two equal time intervals (Time Delta). The purpose of the comparison is the difference between data series (delta) in each of the two possible scenarios. Using this comparison methods, the difference between data series (delta) for each of the possible scenarios can be easily analysed.

Object Delta

The Object Delta analysis is used to display the differences between the measurements of two different objects over the same time period.

Object_Delta.jpg

The Object Delta chart

The values illustrated by the Object Delta charts are obtained from the following contexts:

  • differences between the intersection of the first chosen object and the available media/KPIs

  • differences between the intersection of the second chosen object and the available media/KPIs

The data obtained from each intersection is referred to as data series. Thus we can say that the Object Delta chart shows the delta of two data series.

The Object Delta chart provides the user with the following operations:

  • the Object Filter - 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_Obj_delta.jpg

    The Object filter button

    Tip

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

  • the Calendar button - expands the panel with the following time selectors:

    Time_selectors.jpg

    The Calendar view

    • the Time range selectors allow the user to select predefined time ranges which 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)

    • the From / To selectors allow the user to select a customer Start and End date

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

  • the Media and KPI selectors - reveals the settings which allow the user to select the media and KPIs to be displayed in the charts.

    Media_and_KPIs.jpg

    The Media and KPIs selectors

    Because the chart can display only two unit axes, only two measurement unit types can be selected simultaneously. However, this doesn't mean that only two medias/KPIs can be selected for display. As long as the selected media/KPIs have the same or maximum two different units, all the available media/KPIs can be selected for rendering in the chart.

    When the maximum limit of two different units have been selected, the other available medias/KPIs are disabled automatically.

  • the Chart settings button opens the section that allows the user to configure how the data series are represented in the charts.

    Chart_settings_Obj_Delta.jpg

    The Chart settings view

    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:

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

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

  • the XLS Export button exports the data displayed in the chart to an Excel format.

    XLS_Obj_delta.jpg

    The XLS Export button

The central view of the Object Delta panel is the chart system. This is where the measurement values and the deltas of the two objects are displayed, based on the selected medias/KPIs and time options, as follows:

measurements_chart.jpg

The Delta and Measurement charts

  • The delta chart (top) displays the difference (delta) between the measurements taken on the two objects, using the selected media/KPI.

  • The measurements chart (bottom) displays the actual measurements of the two objects, using the selected media/KPI.

Both charts support 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.Both charts support 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.

A chart tooltips are displayed when hovering the mouse cursor over any of the two charts.

  • The delta chart tooltip displays the time stamp, medias/KPIs names, the values of the measurements currently hovered and the measurements delta of the two objects.

    delta_tooltip.jpg

    The Delta chart toltip

  • The measurements chart tooltip displays the measurement time stamp, the media/KPI names and the values currently hovered.

    Measurements_tooltip.jpg

    The Measurements chart tooltip

The bottom section of the Object Delta 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 the objects and their medias/KPIs displayed in the chart, over the complete time range.

Aggregated_values.jpg

The aggregated values view

The aggregation is done by taking into account the media/KPI type (measurement unit). 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 switching of the viewing mode.

Table_view.jpg

The aggregated values in table view mode

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

Chart_legend.jpg

The chart legend

The legends can also be used to toggle on or off the representation of deltas, by clicking on the legend labels of the corresponding medias/KPIs.

The zoom chart allows the user to narrow down (zoom in) on a specific area of the time range from which the measurements (and delta) are displayed. The zoomed area can be expanded or moved anywhere in the original time interval.

zoom_area.jpg

The zoom chart

The zoom chart shows the overall measurement trends and helps the user in locating the desired section by displaying the general measurements variation for the whole time range (similar to the measurements chart). The delta and measurement charts 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.

Time Delta

The Time Delta is used to display the differences (delta) between the measurements from a single object over two different, equal time spans.

Time_delta_chart.jpg

The Time Delta chart

The values illustrated by the Time Delta charts are obtained from the differences between the intersections of a single object, the available medias/KPIs and two different (but equally long) time intervals. The data obtained from each intersection is referred to as data series. Similar with the Object Delta chart, we can say that the Time Delta chart also shows the delta of two data series, but, as explained above, the data series are obtained differently.

The Time Delta chart provides the user with the following operations:

  • the Object Filter - By clicking the Open Filter toolbar button, the Object Filter panel is opened. In this view the user can select one entity for which the time comparison to be processed.

    Open_filter.jpg

    The Object filter button

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

  • the Calendar button - expands the panel with the following time selectors:

    Time_selectors.jpg

    The Calendar view

    • the Start date 1 vs the Start date 2 allow the user to set the beginning date and time for the first and the second time intervals.

    • the Comparison period represents the length of the two intervals to be compared.

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

  • the Media and KPI selectors - reveals the settings which allow the user to select the media and KPIs to be displayed in the charts.

    Media_and_KPIs.jpg

    The Media and KPIs selectors

    Because the chart can display only two unit axes, only two measurement unit types can be selected simultaneously. However, this doesn't mean that only two medias/KPIs can be selected for display. As long as the selected media/KPIs have the same or maximum two different units, all the available media/KPIs can be selected for rendering in the chart.

    When the maximum limit of two different units have been selected, the other available medias/KPIs are disabled automatically.

  • the Chart settings button opens the section that allows the user to configure how the data series are represented in the charts.

    Chart_settings.jpg

    The Chart settings view

    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:

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

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

  • the XLS Export button exports the data displayed in the chart to an Excel format.

    Excel_export.jpg

    The XLS Export button

The central view of the Time Delta panel displays the delta values chart and the measurements chart, resulting from the two compared time ranges, as follows:

  • The delta chart (top) displays the difference (delta) between the measurements taken over the two time ranges, on the same single object, using the selected media/KPI.

  • The measurements chart (bottom) displays the actual measurement values of the two time ranges, on the same object and using the selected media/KPI.

Delta_and_measurements.jpg

The Time Delta charts

Both charts support 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.

By hovering the mouse cursor over any of the two charts, a tooltip is displayed:

  • The delta chart tooltip displays the time index (using the start + H:m or start + days format), medias/KPIs names, the values of the currently hovered measurements and the measurements delta of the two time intervals at that point.

    Delta_tooltip.jpg

    The Delta tooltip

  • The measurements chart tooltip displays the time index (using the start + H:m or start + days format), medias/KPIs names, the timestamp of each measurement and the value of each measurement for each of the two time intervals, at the current point.

    Measures_toltip.jpg

    The Measures tooltip

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

Chart_legend.jpg

The chart legend

The legend can also be used to toggle on or off the representation of deltas, by clicking on the legend labels of the corresponding medias/KPIs.

The zoom chart allows the user to narrow down (zoom in) on a specific area of the time range from which the delta and measurement values are displayed. The zoomed area can be expanded or moved anywhere in the original time interval.

zoom_area.jpg

The zoom chart

The zoom chart displays the overall measurement trends and helps the user in locating the desired section by displaying the general variation of the two measurements (same object, different time ranges, similar to the measurement chart). The resolution and data of the delta and measurement charts 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, for each of the two time periods.

The bottom section of the Time Delta panel represents the aggregated values of the media displayed by the charts. This section acts like a summary, stating the total or average measurements for all the medias/KPIs displayed in the chart, over the complete time range.

Aggregate_values.jpg

The Aggregate values section

The aggregation is done by taking into account the media/KPI type (measurement unit). 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 switching of the viewing mode.

Table_view.jpg

The aggregated values in table view mode