Charts

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 :

Reset to default: Settings will change back to default settings based on the timeframe set.
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.

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

First date field is the default settings for Datefield
Toggle: Downsample / Raw data
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.

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.

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

Example - Downsampled Data

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:

event_time is the base default date time field for Analysis
If a workgroup-level 'analysis date/time field' is active in the workgroup's settings, it will be used as the default in Analysis
If a date field is selected in the "Date field" drop-down on the Analysis page, it will be used as the default
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
If rules 2-4 are not able to provide a suitable date time field, Analysis will fall back to using event_time

Chart Controls

From left -> right :

Pointer
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
Display values - by default, point values will be displayed in tooltips when series are hovered. For large numbers of series, this can be switched to legend values display and be able to sort by name, ascending or descending values.
Reset chart view - Re-render the chart from the initial display
Download
1. Export a CSV file version of the chart
2. Export a PNG image of the current rendered chart