Common Elements Used in this Topic

Field or Control Description

Pagelet Settings iconPagelet Settings

Click the Page Settings icon to access the pagelet settings. Values are:

Refresh Pagelet iconRefresh Pagelet

Click the Refresh Pagelet icon to refresh the contents of the pagelet.

Options Menu iconOptions Menu

Click to open the Options Menu and select an action to perform on the pivot grid or chart. Available actions are:

  • Prompts: Click to access the Datasource Prompts page to view or change the Query prompts used for the pivot grid.

  • View Grid: Click to view data in the grid format in a new modal window. You can change how data is presented in the grid by dragging and dropping segment data to a different axis.

  • Export Data: Click to export the underlying PSQuery data into a spreadsheet.

  • Chart Options: Click to open the User Charting Options page where you can change the chart layout, information displayed on chart axes, and filters.

  • Save: Click to save the current grid and chart layout as the default view of the current model.

Filters

Displays the filtering fields that are selected in the chart options. Users can use the available filters to change the data to be displayed in the pivot grid or chart.

Bar Chart iconLine Chart iconPie Chart iconHorizontal Bar Chart iconPivot Grid Chart Types

Click to display data in the chart type represented by the icon. Available chart types include vertical bar, line, pie and horizontal bar.

For more information on pivot grid functionality, see the product documentation for PeopleTools: Pivot Grid.