Skip to main content

Describe a Bar Chart

Important

Describe a Bar Chart app updated in Arria for MicroStrategy 3.4.0

After upgrading to Arria for MicroStrategy 3.4.0, you can no longer reconfigure existing Describe a Bar Chart narratives. When you see the pop-up shown below, click Cancel to keep the existing narrative or Continue to overwrite it and configure a new narrative using the redesigned app.

arria-apps-updated-bar-chart.png

See NLG Apps optimizations for further guidance.

About the narrative

Details covered in the analysis

The length of the narrative and the insights it includes depend on the number of measures and dimensions selected and the configuration of the Narrative length option. Choose to generate a Summary that describes only the most significant insights derived from the dataset or configure a more detailed narrative using My key insights.

Example: Analysis of Profit by Country and Segment

The narrative includes:

  • A summary of the overall total for Profit, the number of Countries, the most significant contributors, and, if they exist, outliers.

    arria-apps-bar-chart-d1.png
    • For each Country: the total, average, median, and mode (if the same value appears more than once), and the distribution of Profit across Segments highlighting any outliers.

      arria-apps-bar-chart-d2.png

Tip

Set the order of dimension drilldown in Step 2 of the NLG Apps wizard.

Set the threshold for including drivers and offsets (dimension instances) and the order in which they're described (ascending or descending) using the Narrative length field in Step 3.

See Narrative options for further guidance on configuring the narrative.

Note

From Arria for MicroStrategy 3.4.0 onward, the Describe a Bar Chart app no longer provides the option to analyze variance over time. To analyze variance over time, use the Time-Based Variance app.

 

Top

Data requirements

All NLG apps have the same data requirements for field names and formats. See 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:

bar-chart-temp.png

The requirements for dimensions and measures are:

Minimum

Maximum

One measure and one dimension*.

Unlimited measures and two dimensions*.

 

*The Bar Chart app treats time dimensions in the same way as non-time dimensions. For example, select the Year and Quarter fields to analyze the distribution of profit over a year, broken down by quarter:

arria-apps-dates-as-non-time.png

To analyze variance over time, use the Time-Based Variance app.

Not all combinations of aggregation and entity types are supported for measures. The Describe a Bar Chart app can analyze the following combinations:

arria-apps-entity-aggregation-bar-chart-ms.png

Note

Set entity types and other data attributes in Step 2 of the NLG Apps wizard.

 

Top

Narrative options

You can configure these narrative options in Step 3 of the NLG apps wizard:

arria-apps-narrative-options-bar-chart.png

You have two options to control the verbosity of the narrative and the priority of the insights found:

Summary

Choose Summary to generate a brief overview of the main insights.

arria-apps-narrative-length-summary.png

My key insights

Choose My key insights to control which insights are included in the narrative.

arria-apps-my-key-insights.png

For each level of drilldown, the Describe a Bar Chart app sorts dimension instances in order of contribution to the dimension's total.

The example below shows part of an analysis of Profit by Country and Segment. The narrative describes the total Profit for Ireland — reporting the values for total Profit, average Profit, and median Profit — then describes the contributors to total Profit.

arria-apps-bar-chart-descending-example-all.png

The contributors are Segment dimension instances (e.g. Oil and Gas). The Describe a Bar Chart app sorts the dimension instances according to their contribution to the total Profit in Ireland.

At each level of drilldown, the My key insights option offers three ways to set the sort order for dimension instances and control how many instances are described in the narrative.

Number of instances (default option)
arria-apps-narrative-length-number.png
  • Select the number of instances to include in the narrative.

    Default: 2 instances

  • Choose to sort dimension instances in ascending or descending order.

    Default: Descending

 

Example

Assume the sort order is descending.

If you select 2 instances, the narrative only drills down into the top two contributors.

Contribution
arria-apps-narrative-length-contribution.png
  • Select the threshold percentage for including dimension instances in the narrative.

    Default: 50%

  • Choose to sort dimension instances in ascending or descending order.

    Default: Descending

 

Example

Assume that the threshold percentage is 50% and the sort order is descending.

In this case, the Describe a Bar Chart app sorts the dimension instances from lowest to highest in terms of contribution to the total Profit. The app then works through the list of dimension instances from top (highest contributor) to bottom (lowest contributor), summing the contributions until the total represents a 50% (or greater) contribution to the total.

If the app reaches the threshold by summing just the top two dimension instances, the narrative only drills down into those two dimension instances.

Let Arria decide
arria-apps-narrative-length-arria.png
  • The list of dimension instances is sorted in descending order.

  • Arria's algorithms select the most significant insights to include in the narrative.

 

Top