Charts

Requirements

To render charts on the Analysis page, your browser must support WebGL.

Introduction

Charts are integral to [ANALYSIS] tab.

Here you will select your devices data to display data in a graphical format based on time periods.

On entry into the [ANALYSIS] tab, the Ardexa Web App will auto-load a list of your devices on the left-hand side of the screen.

• Select a device to start. If data-capturing scenarios have been defined against your device they will appear as a list of sources below the selected device.

• Select one or more sources to analyse

• Optionally, select a [Timeframe]

• Select from a list of available [Field]/s to display that data in a chart.

• Adjust settings if needed. Options are: Datefield, Downsample (interval & function) or search for Raw data.

Your chart will draw automatically

Timeframe Picker

Before selecting your source's fields choose an appropriate Timeframe that you would like to chart

Custom Timeframes

Custom timeframes are also available to build your analysis for specific periods.

The timeframe picker offers you the ability to select a custom timeframe to suit your needs based on periods of:

Click on the calendar icon of the start and end date fields to chose your timeframe.

The timeframe is only applied when you click on the [Update] button.

Chart Settings

This tab allows you to modify how your chart data is generated and change how it appears

From left -> right :

1. Copy and open: (New) Copy the url of the current analysis tab with all the chart selections and it will trigger a duplicate tab.

   1. Selection includes: device, sources, fields, settings and timeframe.

   2. In scatter charts, selected x-axis is also included.

   3. For Analysis Entities, it will include the targetted entity instead of the device.

2. Reset to default: Settings will change back to default settings based on the timeframe set.

3. Advanced Settings: Set a minimum base unit values and maximum base unit values.

   Note: The data generated by your devices may return values above or below a threshold that you are interested for analysis. These toggle allow you to apply an upper and lower numerical limit.

Advanced Settings

Hint: limits apply to all datasets in the current chart irrespective of their data range.

1. Chart types - Line, Column and Scatter plot (new) series

2. Time Reference - view and compare 2 different timeframes

   1. Sample:

      
3. First date field is the default settings for Datefield

4. Toggle: Downsample / Raw data

5. If Downsample is toggled ON and timeframe is set to 7 days, interval is hour and function is average

As of September 2024, Analysis is no longer limited to 10,000 data points.

Notes

• Persistent Series Colors

  • Chart series colors are retained when toggling sources on or off. Colors will remain consistent unless the chart is reset or returns no data — making it easier to track series without getting lost in color changes.

• Boolean values, eg. alarms, are converted to 1s or 0s for rendering in the chart.

Down-sampling

Down-sampling allows you to generate charts over very large datasets by aggregating values over a time interval.

For timeframes of Last hour ,Today ,Yesterday only, by checking the [Downsample] field you will then have the ability to choose a downsample [Interval] for your chart.

Other, larger timeframes, will initially use down-sampling with a default interval. After the initial display, you will have the opportunity to change the interval and function applied.

Downsample Interval

Hint: If available for your selected timeframe, select your down-sample interval before selecting your source fields for improved charting performance.

This feature is particularly useful for large datasets. Downsampling can be used to chart result sets containing up to 250 thousand data points.

The aggregation applied to each minute interval is taken from [Fields] input field (auto-displayed to you when [downsample] is checked).

Example - Raw Data

Downsample: off

Example - Downsampled Data

Downsample: on

Note:

• Formulas cannot be applied to down-sampled datasets, i.e they can only be applied to Last hour, Today and Yesterday

• All other timeframes, includingCustom timeframes are automatically down-sampled.

Warning: Under-sampling Down-sampling only works where the underlying base frequency (collected rate) of your data, stored in your table, is more frequent than the down-sample interval you select. i.e. the underlying table data should be collected in data/seconds for this to work effectively. Applying under-sampling to datasets with a collected base frequency greater than the selected interval may produce strange results in your chart.

Warning: maximum result set size

If a downsampled result set will exceed 250 thousand data points, a warning will be displayed, and the data will not be fetched by the system. If this happens, you will need to reduce the size of the result set by:

• choosing a shorter timeframe

• selecting fewer sources and/or fields

• choosing a larger downsampling interval

Date fields

By Default, the Ardexa agent records an event_time field when it captures an event. Some data stored in the Ardexa Cloud can contain one or more date time fields that reflect when an event actually occurred. This pattern is most common when an on-site system captures the data, which is then read by the agent at a later point in time. See event_time and Datetime for more information.

Analysis allows you to visualise data using a selected date time field.

The default behaviour will attempt to resolve the appropriate date time field following these rules:

1. event_time is the base default date time field for Analysis

2. If a workgroup-level 'analysis date/time field' is active in the workgroup's settings, it will be used as the default in Analysis

3. If a date field is selected in the "Date field" drop-down on the Analysis page, it will be used as the default

4. If the default date time field is not present on a given table and source, the first date time field in the record will be used

5. If rules 2-4 are not able to provide a suitable date time field, Analysis will fall back to using event_time

Chart Controls

Chart controls

From left -> right :

1. Pointer

2. Zoom Tools

   1. Move - Click and drag to pan around the chart

   2. Select - Click and drag an area on the chart to zoom in

3. Display values - by default, point values are displayed as Tooltip upon hovering on a data point. For large numbers of series, this can be switched to legend values. It can besorted by name, ascending or descending values.

   

   1. Lock to a Timestamp - When sorting chart data by ascending or descending values, you can lock the chart to a specific timestamp. The chart will snap to the closest available data point, and a vertical guide line will appear. This line can be dragged to a different timestamp for more precise exploration of sorted data.

   
4. Theme - default is set to dark mode. Switching to a different theme (light) will be saved as a user setting and will be applied to all charts except the old charts.

5. Reset chart view - Re-render the chart based from the initial display

6. Download

   1. Export a CSV file version of the chart

   2. Export a PNG image of the current rendered chart

      

Preview:

Chart Table Fields

Charting requires you select one or more fields to be rendered in your chart for the given timeframe.

In the analysis view

• Select a device

• Select a source under the displayed device

• Select the [TABLE FIELDS] tab in the analysis view.

A list of table fields will only populate when a device and a source are first selected.

Hint: Some table field lists will be very long. Use the filter above the list to narrow your search.

Danger: Selecting many multiples of table fields to render in the same chart may cause your browser to become unresponsive.

If this happens you may need to restart your browser.

Chart Types

Line Chart

Default chart type is set to Line which connects a series or multiple series of data points using a line

Line series: Raw search inverter series

Column Chart

Similar with Bar graphs, this is useful for showing data changes over a period of time or for illustrating comparisons among selected sources and fields.

Down-sampling is enabled to address imbalances within a dataset.

Interval default is 1 day which can also be set with 1 hour, 6 hours and 12 hours.

Column series: Daily AC power values over a period 7 days

Scatter Plot

A graphical representation used to explain a possible relationship between two values (X and Y) within a dataset. X axis must be identified to be able to populate the chart.

Down-sampling is enforced for fields that does not belong on the same scenario.

Scatter series: Power generated over WindSpeed in 15m intervals