Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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


  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 is named Demo Pivot
  5. Leave the Pivot Column Source as 'View Data'.
  6. 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"]

...