Ranking Analysis

About the narrative

Details covered in the analysis

The narrative includes:

  • an overview section that summarizes ranking changes in a measure (Profit) for the highest priority dimension (Country). For example:

  • subsections that describe top and bottom ranking changes and when they happened, for up to three dimension drilldowns. For example:



    The order of drilldown is determined by the order of dimensions set in Step 2 of the NLG Apps wizard: Data configuration.

The narrative wording depends on the selected aggregation types, referring, for example, to total, average, minimum or maximum values. For the Percentage, Rating and Ratio entity types, total values are omitted from the narrative as it does not make sense to sum up non-additive measures.

The app attempts to describe as much detail as possible, but when there is too much to describe the narrative will not report on dimensions below the second dimension drilldown.



Data requirements

All NLG Apps have the same data requirements for supported formats and field names. See NLG Apps Data requirements for details.

In addition, each app has specific data requirements:

If your data selection and configuration do not meet the specific requirements for a particular app, the app is disabled in the wizard and a warning message is displayed:


Dimensions and measures

This app can analyze:

  • up to two time dimensions, up to three non-time dimensions, and exactly one measure.

Minimum requirement: one time dimension, one non-time dimension, and one measure.


The Entity Type attribute for time dimensions must be set to DateTime in Step 2 of the wizard.


The Ranking Analysis app can analyze a maximum of one measure.

To replace the default measure with a measure of your choosing, you must first remove it using the Remove button. The Add measure button is displayed only when no measures remain.



*Time dimension requirements for each analysis period:

Analysis period

Required date fields


Date or Year


Date or Year+Quarter


Date or Year+Month


The Entity Type attribute for time dimensions must be set to DateTime in Step 2 of the wizard.

Aggregation and entity types

Not all combinations of aggregation and entity types are supported for measures. The Ranking Analysis app can analyze the following combinations:



Entity types and other data attributes are set in Step 2 of the wizard.



Narrative options

The following fields are available to configure in Step 3 of the NLG Apps wizard: Narrative options.





Select a time period to analyze. The time dimensions in your data selection must include the period you select here — either as a Date field, or a Day, Month, Quarter, or Year field.

Default: Month



Choose to report on only the top-ranking dimensions, the bottom ranking dimensions, or both.

Default: Top only