Basic Queries

1. List Values of any Dimension (such as Text or Date or Geo Location fields) in your data:
LIST PRODUCTS
LIST CATEGORIES
LIST YEARS

2. Aggregate any Measure (such as Numeric or Date fields) in your data:
Using default aggregation:
SHOW SALES
SHOW PROFIT
SHOW DISCOUNT

Using explicit aggregation:
SHOW AVERAGE SALES
SHOW MAX ORDER DATE

3. Aggregate any Measure over any Dimension in your data:
SHOW SALES BY CUSTOMER
SHOW PROFIT ACROSS CATEGORY
SHOW AVERAGE SALES BY MONTH

4. To see frequency distribution of any Dimension in your data:
FREQUENCY OF CUSTOMERS
FREQUENCY OF CATEGORIES

5. To see frequency distribution of any Measure in your data:
FREQUENCY OF SALES
DECILE FREQUENCY OF PROFIT
QUARTILE FREQUENCY OF UNIT PRICE
PERCENTILE FREQUENCY OF DISCOUNT

Query Suggestions

As you type your question, Vizard provides suggestions:

Format Interface

Configuring Multiple Questions in a Tile

Vizard gives you the ability to ask mustiple questions in the same Tile.  To ask the next question, please click on the Format Interfaceadd another question button:


The visualization will display results for all the questions as long as their results can be combined into a single chart:

Format Interface


Switch between questions by clicking on the respective question number that is Format Interfacedisplayed to the left of the question box:

Compare Query Results

You can compare Data by using the Compare keyword:

Format Interface

Group Query Data

You can group data by using keywords such as comma, by and across:

Format Interface


To group across multiple dimensions, please go to the drill down feature here