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 tables have been defined against your device they will auto-appear as a list of sources below the selected device.

  • Select by checking one or more tables to work with.

  • Select a [Timeframe]

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

  • Adjust the Chart Style if required. Options are line (default) or column

Your graph will auto draw

Improve Chart Performance

Your machines may collect data at a very high frequency. Bringing that data back from your tables to chart as un-aggregated data for Day timeframes will present a performance limit.

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:

Day, Month, or Year

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 [Apply] button.

Downsample

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.

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

This feature is particularly useful for large datasets that will exceed the 10,000 data-point limit or otherwise causing performance problems in your charts.

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

Example - Before Downsampling

Example - After Downsampling

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.

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

Exporting Charts

Any chart in the Ardexa cloud can be exported to an image or CSV file by clicking the download button at the bottom-right of the chart:

Chart download button, with available options