This update (Feb 20, 2018) of the search tool makes it possible to actually search and compute things at the same time.

Calculations are needed whenever you want to summarize numbers appearing in one or more columns according to a criteria. A typical criteria is the time, which is found most of the time in another column of the data and is used as a basis for calculations in time periods.

Calculations in the search tool are triggered by ending the keywords field with a question mark (?).

Let's take an example with the following sample data :


Sample data.

If we type Sales ? in the keywords field, we see the following as output in the result list :


Magically computing sales by entering Sales ?

If we type Sales by RegionID ? in the keywords field, we see the following as output in the result list :


Magically computing sales by entering Sales by RegionID ?

If your data has another measure of interest, such as Volume, you can combine them with "prix ht" by Volume and by Region ?


Combining measures by entering "prix ht" by volume and by region ?

If you are interested in another aggregation function such as min, max, average, count, you may explicitly ask so for instance with max Sales by RegionID ? :


Magically computing maximum of sales by entering max Sales by RegionID ?

For grouping in time, one of the 4 following keywords can be used : WEEK, MONTH, QUARTER, YEAR. As in sales by month ? :


Magically computing sales by month (note : there is no month column in the data)
Keyword list for natural language search :

• aggregation function : SUM, MIN, MAX, AVERAGE, COUNT
• grouping in time : WEEK, MONTH, QUARTER, YEAR
• sorting : TOP, BOTTOM