Search Statistics
Generating statistics over your search results
Last updated
Generating statistics over your search results
Last updated
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.
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.
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
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.
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.
