Select the data to be analyzed
In this tutorial, you'll generate a narrative using the Descriptive Statistics app. Before selecting the data fields to be analyzed, you must consider the data requirements for this app.
Some data requirements — supported formats and field names — are the same for each NLG app. See Data field names and formats for details.
Other data requirements — the minimum number of required fields and the supported combinations of aggregation and entity types — vary by app. You can find these details in the NLG Apps Directory.
Note
The Arria visualization categorizes MicroStrategy attributes as dimensions, and MicroStrategy metrics as measures.
The Descriptive Statistics app has the following requirements:
Minimum number of fields: one measure and one non-time dimension.
Supported combinations of aggregation and entity types:
You've already selected one non-time dimension (Product) and one measure (Profit). Therefore, the current data selection already meets the minimum-fields requirement for the app.
Later in the tutorial, you'll select an entity type for the Profit measure. You must select an aggregation and entity type combination supported by the Descriptive Statistics app. Since Profit is aggregated by Sum, you must select either None or Currency in the Entity Type field.
Next, you'll select two more dimensions and two more measures for the analysis.
First, select only the data for 2021 using the Year filter in the Filter panel.
From the Datasets panel, drag Country and Segment to the Attribute section of the Editor panel.
Drag Sales and Target Sales to the Metric section.
You've added three dimensions (Product, Country, and Segment) and three measures (Profit, Sales, and Target Sales). Next, you'll select the Descriptive Statistics app in Step 1 of the NLG Apps wizard.
Next, you'll select the Descriptive Statistics app in Step 1 of the NLG Apps wizard.
