This section lists examples of how to apply filters in questions.

Comparator Filters
For comparators, you can use things like =, >, >=, < etc
SHOW PRODUCTS WHERE TOTAL SALES > 900
SHOW SALES WHERE PRIORITY = HIGH

You can also combine comparators filers with things like and, or
SHOW PRODUCTS WHERE TOTAL SALES > 90K AND TOTAL SALES < 9M
SHOW PRODUCTS WHERE TOTAL SALES > 1M OR TOTAL UNITS >= 2K

Time Filters
For time filters, you can use things likeJan,Feb 2012,25 January 2012,Q1 2012 etc
SHOW SALES IN FEB 2012
SHOW SALES IN Q1 2012
SHOW SALES LAST QUARTER
SHOW SALES THIS MONTH

Value Filters of non-numeric fields
You can use value of the non-numeric fields like Regions,Categories etc
SHOW SALES IN ALBERTA
SHOW SALES IN TECHNOLOGY

Functions as filters
You can use built-in functions as filters like PERCENTAGE,COUNT,DAYDIFF etc
SHOW STATES WHERE PERCENTAGE(SUM(PROFIT),SUM(SALES)) < 10.5
LIST CUSTOMERS WHERE COUNT(CATEGORIES)=5
SHOW SUB CATEGORIES WHERE AVERAGE DAYDIFF(SHIPPING DATE, ORDER DATE)>2