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
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
. The view shows the total 'Random_Number' value per 'Random_Date' and 'Status' value.
Figure 2: 007_Pivot_View1
...