Search Statistics

Generating statistics over your search results

Using [SEARCHES] > [STATS], the Ardexa Web App provides to you, a number of common pre-set statistical formulae that you can apply over your search results.   
Save your time; there's no need to export to csv and manipulate your data in a spreadsheet to generate a stats report. You can do it directly within the Ardexa Web App [SEARCHES] view in the matter of moments.
STATS -  Statistical Formulae Available to Your Searches
The Ardexa Web App provides the following statistical formulae for you to apply of your search results:
Stats:
Formula
Simple Description
count
The number of data points returned.
min
The lowest value found in the data set.
max
The highest value found in the data set.
avg
A measure of central tendency of the data using the arithmetic mean.
sum
Total of a values when added together.
Extended Stats:
Formula
Simple Description
sum_of_squares
A measure of the overall variance or deviation of a data set from its mean.
variance
A measure of how far a set of (random) numbers are spread out from their average value.
std_deviation
A measure of the amount of variation or dispersion of a set of values. A low result indicates values tend to be close to the mean. High result indicates values are spread out over a wider range.
std_deviation_bounds
the interval defining where a certain percentage of the population is likely to lie.
Note: Statistics, can only be applied against numerical data type fields.‌
Generating a STATS Report
‌The following will step you through the process of building your STATS report.‌
Run a Search
‌We have to generate some search results to apply formulae, so we run a search to get some results. All the search input parameters will be used to generate the data that the STATS report will be built from.‌
When you first run a search via the
button, the [TABLE] tab may be selected and the search results will be presented to you in the table format​; switch over to the [STATS] tab. 
 
Enable STATS for your Search
‌Select the [STATS] tab and enable statistics via the Enable checkbox. This allows you to begin building your STATS report. 
How Generate a Simple STATS Report
Select [Output] to expand the STATS output parameters if they are hidden. This is where you will define what the STATS will be generated over your search results. 
Field 
Select a numerical field type from the drop-down list.
If you don't see an expected field it will likely mean the field has not be defined correctly in your Ardexa device's metadata.
​Type (definitions of each are provided above here)​
stats 
extended_stats a measure of the amount of variation or dispersion of a set of values
sum
Run the STATS Report
Click the
button to generate your statistical report.
NOTE: The selected statistical formulae under [Type] are applied to your search results when your search is executed via the the 
 button.   For this reason, when you select/re-select the [Type] the search may have to be re-generated, requiring you to click on the [GO] button again.

Search Visualisations - VIZ

Search Analysis

Last modified 3yr ago

Formula	Simple Description
`count`	The number of data points returned.
`min`	The lowest value found in the data set.
`max`	The highest value found in the data set.
`avg`	A measure of central tendency of the data using the arithmetic mean.
`sum`	Total of a values when added together.

Formula	Simple Description
`sum_of_squares`	A measure of the overall variance or deviation of a data set from its mean.
`variance`	A measure of how far a set of (random) numbers are spread out from their average value.
`std_deviation`	A measure of the amount of variation or dispersion of a set of values. A low result indicates values tend to be close to the mean. High result indicates values are spread out over a wider range.
`std_deviation_bounds`	the interval defining where a certain percentage of the population is likely to lie.