Pivot tables
Pivot tables are a very powerful way to report across multiple elements. Drag fields into the left hand column and top row to display a count of matches. To show a third set of data, use the settings in the top left-hand corner.
Use any of the filters below with a Pivot table display.
To open the pivot table builder
- Click the Config button
- Choose Pivot table from the Displays column
- Click Apply
Example 1: Number of training items a user has at each stage of completion
- Drag the Username bubble to the left hand column
- Drag the Status bubble to the top row
Example 2: Status of each training item for each user
- Drag the Username bubble to the left hand column
- Drag the Title bubble to the top row
- Change the pivot action in the left top corner from Count to List Unique Values
- Choose Status in the second box that appears
Comments
0 comments
Please sign in to leave a comment.