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.
The Ardexa Web App provides the following statistical formulae for you to apply of your search results:
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. |
Note: Statistics, can only be applied against numerical data type fields.
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. 
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
sum
Click the
button to generate your statistical report.


NOTE: The selected statistical formulae under
button. For this reason, when you select/re-select the
[Type]
are applied to your search results when your search is executed via the the 
[Type]
the search may have to be re-generated, requiring you to click on the [GO]
button again.Last modified 3yr ago