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.
All examples on this page are based on the stream data shown in Figure 1.
Figure 1: Raw stream set data
Table of Contents
| Table of Contents | ||
|---|---|---|
|
...
Example 2: Adding a Total Column to the Basic Pivot View
Figure 2: 007_Pivot_View1
Step-by-step guide
- Open the stream configuration.
- Go to the Views tab.
- Create a new view. Choose the 'Pivot' option.
- Give the view a name. In this example, the view has been named 007_Pivot_View2.
- Leave the Pivot Column Source as 'View Data'.
- Drag the 'Random Date' attribute from the left hand list into the Row Attribute field.
- Drag the 'Status' attribute from the left hand list into the Column Attribute field.
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.
Drag the 'Random Number' attribute from the left hand list into the Total Attribute field. It will set the aggregate attribute to Sum() by default.
Figure 5: View configuration for 007_Pivot_View2- Save the view.
- If you now open the view, it should look like Figure 4.
Example 3: Multiple row attributes
Step-by-step guide
- Open the stream configuration.
- Go to the Views tab.
- Create a new view. Choose the 'Pivot' option.
- Give the view a name. In this example, the view has been named 007_Pivot_View3.
- Leave the Pivot Column Source as 'View Data'.
Example 4: Using different aggregate functions and formatting fields
Step-by-step guide
- Open the stream configuration.
- Go to the Views tab.
- Create a new view. Choose the 'Pivot' option.
- Give the view a name. In this example, the view has been named 007_Pivot_View4.
- Leave the Pivot Column Source as 'View Data'.
Example 5: Using the maximum pivot columns field
...