NLS terms for aggregation
Cloudera Data Visualization provides Natural Language Search (NLS) support for aggregation concepts.
The aggregate support includes the following functions:
| Function | Example |
|---|---|
|
sum |
Sum revenue |
|
average |
average revenue by store |
|
count |
Visitor count by site |
|
max |
maximum sales by visitor and by site |
|
min |
minimum revenue by store, by campaign, for cost > 5000 |
|
standard deviation |
standard deviation revenue by product, by month, for date after 10/31/2010 |
|
unique count |
unique count visitors last week, by product page |
|
variance |
variance sale amount last year, by visitor and by product |
