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 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.

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 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.