A Pivot Grid is a graphical or tabular representation of analytic or statistical data. Some examples of the types of data that can be displayed in a Pivot Grid are sales data by region or organization, HCM statistical or individual data, or financial and accounting data. The charts displayed are a visual representation of the specific data that has been compiled. A Pivot Grid can pivot and filter data, which enables business analysts to have different views of the same data.
A Pivot Grid can be displayed in three different formats: Chart Only, Grid Only, and Grid Plus Chart. The following figures illustrate these examples.
This option is best when the primary purpose is to present summary level trends or results. Users are able to view the operational reporting data in a chart. All Charts can be displayed in one of four ways: Line Chart, Pie Chart, Bar Chart, or Horizontal Bar Chart. The type of chart is invoked by clicking on a specific icon as shown below:
This allows the user to see the same data in a variety of different formats to suit their needs.
With the Grid Only display option, the grid is displayed without the chart. Users are able to view the operational reporting data in a grid, where data pivoting, slicing, and dicing is possible. A grid can allow multiple columns at once, whereas the chart generally only shows the X and Y axis dimensions.
Use this option when the primary purpose is to provide lots of details and various dimensions to analyze data. Users are able to view the operational reporting data in both a grid and a chart. The data between the grid and the chart is synchronized for an accurate view and also allows for slicing and dicing of data or modeling. That makes this option ideal if the user wants to adjust data in the grid and see the results right away in a chart.
The Grid Plus Chart option means that the data in the chart is always a subset of the data in the grid, and the synchronization between the grid and the chart is unidirectional only. With this option, the drilldown operation on the grid drills down on the chart as well.
Pivot Grids are displayed in either a Modal Window or within a Pagelet in a Dashboard.
When the Pivot Grid is displayed in a Modal Window, the preferred method for invoking a Pivot Grid is through a Related Action. This allows administrators to easily add, edit, and configure the availability of Pivot Grids without special coding. The Related Action link should also contain the downward triangle indicator, because this helps the user understand that a list of options is available.
The following figures illustrate how a Pivot Grid is invoked in a Modal Window using a Related Action link. Clicking the Related Action link opens the specified Pivot Grid in a Modal Window. The following figures illustrate this three-step process.
Clicking on the Headcount Analytics link on the bottom of the page invokes the Pivot Grid Related Actions, as shown in the figures below.
A Pivot Grid can also be displayed within a Pagelet on a Dashboard if it is relatively straightforward and can be displayed without appearing too cramped. The display of the Pivot Grid should also include space for the display of global parameters if they are needed.
Both methods could require the user to select filters or other values before the Pivot Grid can be displayed
It is possible to add Related Actions to a Detail View grid. This allows the user to take action on a particular piece of data.
If applicable, try to add at least one Related Action from the Detail View grid that shows the source of the data (to provide a way to go to the primary component associated with that data).
Related Actions from the Detail View of a grid should not use a Modal Window if the transfer opens a transaction page. Use a Modal Window if the related action displays read-only content, or is self-contained without navigation links to other components.
Pivot Grid Settings are accessible from the Gear icon shown in blue in the figure below. When the user clicks on the Gear icon, a pull-down menu appears listing the available actions.
When the user selects Chart Options as shown above, a new window opens as shown in the figure below.
The user can click on the spreadsheet icon as shown below to download the data
When the user clicks on the question mark icon, the Help Screen is displayed.
Pivot Grid Filters appear as drop-down lists. Users may select one or multiple values from each filter to further refine which data is displayed. Some pivots have many available filters, so the user may wish to temporarily hide these filters to provide more room for viewing the grid or chart. This is illustrated in the following figures where the filters can be toggled on or off from the “funnel” icon on the Pivot Grid Header.
In the figure below, the filters are showing and the user clicks on the “funnel” icon as shown below to hide the filters.
In the figure below, the filters are now hidden from view.