Skip to main content

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 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.

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-tsf.png

Now, you'll add three dimensions and three measures (aggregated by Sum) to the Intelligent Narratives visualization.

  1. First, in TIBCO Spotfire Analyst, open the Data in analysis flyout and select only the data for 2021 by filtering the Year field.

    tibco-spotfire-arria-filter-data.png
  2. In the Intelligent Narratives visualization, click the Legend icon to close the legend.

    tibco-spotfire-arria-click-legend-icon.png
  3. Click the Properties icon to access the Intelligent Narratives Properties pop-over.

    tibco-spotfire-arria-click-properties-icon.png

    Next, you'll add the columns you'd like to analyze. TIME, LOCATION, and CATEGORIES columns are added to the Dimensions section and NUMBERS columns are added to the Measures section. See Data field names and formats for more information.

  4. On the left, click Dimensions. By default, Dimensions is already populated with one column: in this case, Country.

    tibco-spotfire-arria-click-dimensions.png
  5. In the Columns selector field, click the Plus icon and add the Product column.

    tibco-spotfire-arria-add-product.png
  6. Repeat Step 5 to add the Segment column.

    You're nearly ready to start adding NUMBER columns to the Measures section. First, you need to add (Column Names) to the Dimensions section. This is required whenever you wish to analyze more than one NUMBER.

  7. Repeat Step 5 to add (Column Names).

    You now have the following columns in the Dimensions section:

    tibco-spotfire-arria-add-dimensions.png
  8. On the left, click Measures. By default, Measures is already populated with one column: (Row Count).

    tibco-spotfire-arria-click-measures.png
  9. In the Columns selector field, click (Row Count) and change it to Sales. Leave the aggregation type as Sum.

    tibco-spotfire-arria-change-row-count-to-sales.png
  10. Add the Target Sales and Profit columns, leaving the aggregation type as Sum for each.

    tibco-spotfire-arria-add-measures.png
  11. Close the Intelligent Narratives pop-over.

 

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.