This section lists some examples of basic questions.
Enumerate over all values of a non-numeric field
Plot the sum total of a numeric field likeSales
For metrics, we can use things likeMaximun,Minimum,Average,Total
Plot the frequency of a field likeCustomers,Categories
Plot the frequency distribution of a field likeDecile,Quartile,Percentile
For ranking, you can use things likeTop,Bottom
For time range, you can use things likeYears,Months,Weeks
For time range, you can use keywords likeLatest,Earliest
You can perform basic mathematical operations likeAddition,Multiplicationetc
You can perform basic mathematical operations on numeric fields likeSales,Unitsetc
This section lists some examples of questions to compare two or more fields.
You can compare variations of multiple numeric variables against non-numeric entities
You can compare trends in various numeric variables across time. The time variables can be any ofyears,quarters,months,weeks,daysorhours
You can see the comparison of the same graph as a particular non-numeric/time entity is varied
You can see the comparison of the same graph as a particular non-numeric/time entity is set to different explicit values
This section lists examples of questions to group data at multiple levels.
Data can be grouped at multiple levels by usinginoracrosskeywords.
Following are some examples of questions that group data at multiple levels:
This section lists examples of how to apply filters in questions.
For comparators, you can use things like=,>,>=,<etc
You can also combine comparators filers with things likeand, or
For time filters, you can use things likeJan,Feb 2012,25 January 2012,Q1 2012etc
You can use value of the non-numeric fields likeRegions,Categoriesetc
You can use built-in functions as filters likePERCENTAGE,COUNT,DAYDIFFetc
A place where cool druids hang out to build hot products