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 as set in Step 1 (Country). For example:
subsections that describe top and bottom ranking changes and when they happened, for up to three dimension drilldowns. For example:
Note
The order of drilldown is determined by the order of dimensions set in Step 1.
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.
Note
Only the Important things narrative length is available for this app in Step 3.
Data requirements
All NLG Apps have the same data requirements relating to supported formats and field names. See the NLG Apps Data requirements topic 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 grayed out and disabled in the wizard. In this example, the Describe a Pie Chart app has been disabled:
 |
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.
*Time dimension requirements for each analysis period:
Analysis period | Required date fields |
|---|---|
Year |
|
Quarter |
|
Month |
|
Important
For each time dimension, the Entity Type field must be set to DateTime in Step 1 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:
 |
Tip
Aggregation types are set in Power BI.
Entity types and other data attributes are set in Step 1 of the Arria for Power BI wizard.
Configuration options
The following options are available to configure:
OPTION | DESCRIPTION | LOCATION |
|---|---|---|
Measure | Select the measure you want to analyze. Default: |  |
Period | Select a time period for the analysis. The time period you select must appear as a field in your data. Default: |  |
Ranking | Specify whether you would like to include only the top ranking changes, only the bottom ranking changes, or both. Default: |  |
