Data Synchronization Between the Grid and the Chart
The grid and chart event listener captures grid events and constructs an appropriate PSQuery using the row and column labels and filters. Each user action results in an appropriate event for the chart, so that both the chart and the grid are synchronized. Pivot Grid enables users to move the fields among the row, the column, and the report filter. Each of these actions results in a different view of the same data.
The chart event listener captures chart events and constructs an appropriate PSQuery using the chart axis and filter information.
If users select Pivot Grid and Chart as the display option, the data that appears in the controls is synchronized. Synchronization is achieved using the following two mechanisms:
Unidirectional synchronization.
The flow between the chart and the grid is maintained in a single channel, unidirectionally. Only an event or a user action in the grid will result in the chart being regenerated.
Semi-intelligent chart axis.
Pivot Grid determines the chart axis information intelligently based on the grid layout and maintains synchronized data between the grid and the chart. Therefore; the data in the chart is always a subset of the data in the grid.
Pivot Grid is able to set the chart axis information correctly so that the chart always displays a subset of the grid data. Pivot Grid always sets the field at the highest level on the row axis of the grid as the X axis for the chart. When you change the grid layout, the X axis for the chart keeps changing based on the grid layout. You can choose the Y axis in all scenarios except when any values are dragged to the filter axis on the grid. In this case, the value selected on the filter of the grid will be the Y axis for the chart as well.
This table describes various actions you can perform on the grid, and the corresponding actions on the chart that maintain synchronization.
Action in Grid |
Action in Chart |
---|---|
Drilling down in the grid by clicking the plus (+) icon on the row axis Note: In PeopleSoft Pivot Grid, this action is available only at the lowest level of the row axis in the grid. |
This grid action will result in a drill down in the chart as well. Earlier, the chart would have displayed the All member for the axis field, but now the chart also shows the relevant details. The Y axis does not change. |
Moving a row to the report filter |
This grid action will result in:
|
Moving a row to the column |
This grid action will result in:
|
Moving a column to the report filter |
This grid action will result in:
|
Moving a column to the row |
This grid action will result in:
|
Moving values to the report filter |
This grid action will result in:
|
Moving values to the row axis |
This grid action is essentially the same representation of data as comparing values on the column axis except that the data view is vertical rather than horizontal. Therefore, no change will appear in the chart. |