Charts
Last updated
Last updated
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
Before selecting your source's fields choose an appropriate Timeframe that you would like to chart
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.
This tab allows you to modify how your chart data is generated and change how it appears
From left -> right :
Copy and open: (New) Copy the url of the current analysis tab with all the chart selections and it will trigger a duplicate tab.
Selection includes: device, sources, fields, settings and timeframe.
In scatter charts, selected x-axis is also included.
For Analysis Entities, it will include the targetted entity instead of the device.
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.
Chart types - Line, Column and Scatter plot (new) series
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 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).
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
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
From left -> right :
Pointer
Zoom Tools
Move - Click and drag to pan around the chart
Select - Click and drag an area on the chart to zoom in
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.
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.
Reset chart view - Re-render the chart based from the initial display
Download
Export a CSV file version of the chart
Export a PNG image of the current rendered chart
Preview:
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.
Default chart type is set to Line which connects a series or multiple series of data points using a line
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.
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.