How To: Create Pivot Views

Sometimes the user may wish to reorganise and summarise data in a stream set to get a desired report. The pivot view functionality allows the user to use a stream view attribute's values as the rows against which all other data is reported.

Example 1: Basic Pivot View

These instructions describe how to configure a view to look like Figure 2, rather than the standard aggregated grid view version of the same data shown in Figure 1.

Figure 1: 007_Grid_View1

Figure 2: 007_Pivot_View1

Step-by-step guide

1. Open the stream configuration.
2. Go to the Views tab.
3. Create a new view. Choose the 'Pivot' option.
4. Give the view a name. In this example, the view has been named 007_Pivot_View1.
5. Leave the Pivot Column Source as 'View Data'.
6. Drag the 'Random Date' attribute from the left hand list into the Row Attribute field.
7. Drag the 'Status' attribute from the left hand list into the Column Attribute field.

8. Drag the 'Random Number' attribute from the left hand list into the Value Attribute field. It will set the aggregate attribute to Sum() by default.

   

   Figure 3: View configuration for 007_Pivot_View1

9. Save the view.
10. If you now open the view, it should look like Figure 2.

Related articles