NLS Terms for Aggregation

Arcadia Instant provides Natural Language Search support for aggregation concepts.

The aggregate support includes the following functions:

Summation

Function
sum
Example
Sum revenue

Average

Function
average
Example
average revenue by store

Count

Function
count
Example
Visitor count by site

Maximum

Function
max
Example
maximum sales by visitor and by site
>

Minimum

Function
min
Example
minimum revenue by store, by campaign, for cost > 5000

Standard Deviation

Function
standard deviation
Example
standard deviation revenue by product, by month, for date after 10/31/2010

Unique Count

Function
unique count
Example
unique count visitors last week, by product page

Variance

Function
variance
Example
variance sale amount last year, by visitor and by product