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 thebutton, 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.
extended_stats a measure of the amount of variation or dispersion of a set of values
sum
Run the STATS Report
Click thebutton 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.
button, the 
button to generate your statistical report.