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 NLG Apps reference > Data requirements 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:

    arria-apps-entity-aggregation-descriptive-statistics-ms.png

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.

  1. First, select only the data for 2021 using the Year filter in the Filter panel.

    microstrategy-arria-filter-year.png
  2. From the Datasets panel, drag Country and Segment to the Attribute section of the Editor panel.

  3. Drag Sales and Target Sales to the Metric section.

    microstrategy-arria-add-attributes-metrics.png

 

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.