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 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.
Tip
Set the order of dimension drilldown in Step 2 of the NLG Apps wizard.
See Narrative options for further guidance on configuring the narrative.
Data requirements
All NLG apps have the same data requirements for field names and formats. See Data field names and formats for details.
In addition, each app has specific data requirements:
Dimensions and measures
The requirements for dimensions and measures are:
Minimum | Maximum |
|---|---|
One measure, one time dimension*, and one non-time dimension. | One measure, two time dimensions*, and three additional dimensions. |
*Time dimension requirements for each analysis period:
Analysis period | Required fields |
|---|---|
Month |
|
Quarter |
|
Year |
|
Note
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.
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:
 |
Note
Entity types and other data attributes are set in Step 2 of the wizard.
Narrative options
You can configure these narrative options in Step 3 of the NLG apps wizard:
OPTION | DESCRIPTION | LOCATION |
|---|---|---|
Period | 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 as Day, Month, Quarter, or Year fields. Default: |  |
Ranking | Choose to report on only the top-ranking dimensions, the bottom-ranking dimensions, or both. Default: |  |
