NOTE: All the example Questions in this page use this Example Dataset.

Keywords for Grouping

In the previous section, we have listed different Types of Measures. All of those measures can be grouped by Dimensions. Use one of these Keywords to group Data by a Dimension:

The various types of Dimensions are described below:

Grouping by Fields

You can group Measures by Text/Geo-Location Fields as shown below:

You can also group Measures by Number or Date Fields in the same manner, but they are not usually needed.

In general, you'll group by Date Fields using Time Periods as explained below:

Grouping by Time Periods

Basic Time Periods

You can use the following Time Periods when grouping your data:

Examples:

Calendar-based Time Periods

You can also use these Calendar-based Time Periods for grouping:

Examples:

Financial Time Periods

You can also group using Time Periods based on your Financial year (FY). The start of the Financial-year can be configured in the Data-Model. Here are the various FY-based Time Periods:

Examples:

Grouping by a List of Values

You can also group Measures by specific values of a Dimension. This works for all the above Dimensions.

Examples:

Please note that you'll have to use at least 2 values for the grouping to work. If you use just a single value, it'll be considered as a Filter.

Also note that all the values must be from the same Dimension.

Grouping by Functions

You can also use various Functions as Dimensions. See Using Functions for a list of supported Functions and how to use them.

Drill-down

You can use multiple Dimensions in the same Question using Commas, AND or the Grouping Keywords in between.

Examples:

The resultant chart is called a Drill-down Chart because you can drill down from one Dimension to another. The order of Dimensions in the Question will determine the order of Drill-down in the chart. You can see Drill-down in action below: