...
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
- 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 is named Demo Pivot
- Leave the Pivot Column Source as 'View Data'.
- In the View Attribute pane, insert the attributes you require
...
To correctly set up the column sort the expression must point to the Pivot Column.
To showcase this I we want thee the pivot view to only display these Column Names in this particular sort order: Handset , Internet, Voicemail, SIM_Only the expression to be written in the "Pivot Column Expr" field will look like this : ["Handset", "Internet", "Voicemail", "SIM_Only"]
...