Show TOC

Procedure documentationCreating and Configuring the Chart Locate this document in the navigation structure

 

In this example, you display the results of your Top N query in a chart instead of a table. You reconfigure the data service's Output port to generate a chart, and you configure the chart.

Prerequisites

You have created the query in Creating the Query and it is open in Storyboard.

Procedure

  1. Delete the table view:

    On the Design tab, select the table view and delete it.

  2. Create and attach a chart to the query output port:

    1. From the Compose Model task panel, select Chart view and drag it to the workspace where the table view was.

    2. Click the Output port of the Top N query and drag to connect to the In port of the chart view:

      Attaching a Chart (Attaching a Chart)

  3. Configure the chart's labels and axes:

    1. Double-click the chart view to open the Configure Element task panel.

    2. In the Chart title field, enter Top and Bottom 3 Materials by Incoming Orders Value.

    3. Configure and label the category axis:

      In the Category Axis section, you want to specify that the materials should be displayed along the X-axis of the chart. To do this, select the technical name, F0D_MATERIAL, from the Field drop-down list. Enter Material in the Axis label field.

      Note Note

      Select F0D_MATERIAL and not F0D_MATERIAL_KEY as the category axis. F0D_MATERIAL_KEY would display the technical name of the material instead of the material name itself along the axis:

      End of the note.

      Configuring the Category Axis (Configuring the Category Axis)

    4. Configure the value axis:

      The Y-axis, or value axis, of the chart is bound to the data series, which we configure in the next step, so we can leave all the entries as they are here. Labeling the axis is unnecessary because the data series provides a legend.

  4. Configure and label the data series:

    1. To indicate where the data is (and hence how to calculate the Y-axis), go to the Data Series section of the panel and click the Add (plus) button to add a series. A series called Series 1 is added.

    2. Select the Formula column of the series and click the drop-down button. From the list, select @Incoming_orders_value_value. This represents the formatted value of the key figure (or measure) that displays the data, Incoming orders value. You can also label the data itself, which provides a legend in our chart. Replace Series 1 with Incoming Orders in the Data Series column:

      Configuring the Data Series (Configuring the Data Series)

  5. Save your model.

Result

Your chart is now configured. You are ready to proceed to Fine-Tuning and Deployment.