Knowledge
English
Search
K
Links

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