Create or Edit Pivot Grids for Visualizations in Projects/Shells

To create or edit Pivot grids for visualizations in a project/shell (Admin mode):

Sign in to Unifier with project/shell administration credentials.
Click the specific project/shell tab and switch to Admin mode. For example, click a tab called Vision Corporation.
In the left Navigator, select Setup, and then select Visualizations.
In the Visualizations log (right pane), select any of the following actions:
- Click Create to add a new visualization in the project/shell. Proceed to step 6.
- Select a visualization in the log and then click Edit. Proceed to step 5.
In the Edit page, click Edit ( )for a Pivot grid in the visualization layout. Proceed to step 6b.
In the Create or Edit page, specify or update the following information:
1. From the Preview Data list, select an active project or shell and click Preview Data to preview the data you can use to create or update the Pivot grid.
2. From the Data Source list, select the data source to use for creating the content item.
3. From the View Type list, select Pivot Grid.
4. In the Name field, enter a name for the Pivot grid.
5. (Optional) In the Description field, enter a short description about the Pivot grid.
6. From the Value list, select a data element from the data source selected above. Displays Count by default.
  For the selected data element in the Value list, select any of the following measures:
  - Average: The mean of all values of the selected data element.
  - Count: (Default) The total number of rows of the selected data element.
  - Max: For numeric fields, displays the highest value. For date fields, displays the maximum date.
  - Median: The central value among all values of the selected data element.
  - Min: For numeric fields, displays the lowest value of the selected data element. For date fields, displays the minimum date.
  - Sum: Sum of all values of the selected data element.
7. From the Columns list, select a data element to create columns for the Pivot grid.
8. (Optional) Click Add Columns to include additional column tiers in the Pivot grid.
9. From the Rows list, select a data element to create rows for the Pivot grid.
10. (Optional) Click Add Rows to include additional row tiers in the Pivot grid.
11. Make changes as needed to refine the above selections.
After making all changes, select any of the following actions:
- Click Create if you created a pivot grid and return to the Edit page.
- Click Update to confirm all the changes made to the edited pivot grid, and return to the Edit page.
In the Edit page, click Save to update the visualization with any created or edited content.

Related Topics