More Options dialog box

You can select additional formatting options for a Graph visualization, Grid visualization, Heat Map visualization, or Network visualization in a dashboard using the More Options dialog box. You can also define how attributes and metrics are joined within the visualization.

The following options are available:

Headers: (Available for Grid visualizations)

Rows: Determine whether to Show, Merge, and/or Lock the row headers in a grid.

Columns: Determine whether to Show, Merge, and/or Lock the column headers in a grid.

Display:

Remove Extra Column: Determine whether the word "Metrics" is displayed on the grid. (Available for Grid visualizations)

Show attribute form names: Determine how headers for attributes and attribute forms are displayed in a visualization. For example, you can choose to have a header containing the attribute form name automatically displayed above each attribute form shown in the visualization, or have a single header automatically displayed for each attribute in the visualization, with each header containing only the attribute name. The following options are available:

Off (default): Select this option to have the attribute name automatically displayed in the header of each attribute. No attribute form names are included.

On: Select this option to have a header automatically displayed for each attribute form, with each header consisting of the attribute name followed by the attribute form name.

Form name only: Select this option to have a header automatically displayed for each attribute form, with each header consisting of only the attribute form name.

Show attribute name once: Select this option to have a header automatically displayed for each attribute form and have the attribute name included only in the header for the first attribute form for each attribute. The remaining attribute forms are displayed using the attribute form name only.

Automatic: Select this option to automatically display either headers for each attribute or each attribute form depending on the number of attribute forms visible in the visualization for each attribute. If only one attribute form is shown for an attribute, the attribute is displayed with a header containing the attribute’s name. If more than one of the attribute’s forms are visible in the visualization, each attribute form is displayed with a header containing the attribute name followed by the attribute form name.

Hide Null / Zero toggle behavior: Select this option to determine how to hide null and zero metric values in a visualization. From the drop-down list, select one of the following:

Show both nulls and zeros (default): Select this option to display rows and columns that consist only of null or zero metric values.

Hide both nulls and zeros: Select this option to hide rows and columns that consist only of null or zero metric values.

Hide nulls only: Select this option to hide rows and columns that consist only of null metric values.

Hide zeros only: Select this option to hide rows and columns that consist only of zero metric values.

Filtering: From the drop-down list, select one of the following options to determine how filtering data through other visualizations works:

Intersection of all selections (default): All the filtering selections are applied.

Last selection only: Only the last filtering selection is applied.

Join Behavior: You can define how all attributes are joined within the visualization. You can also define how each metric in the visualization is joined.

To define additional formatting options for a visualization

Click the name of a dashboard to run it. Click the Graph, Grid, Heat Map, or Network visualization to format.

If the Properties panel is not displayed, from the View menu, ensure that Properties Panel is selected. If the Properties panel is hidden behind another panel, click the Properties icon to display the Properties panel.

From the drop-down list at the top of the Properties panel, select Data Exploration. For a Grid visualization, select General Options.

Click More Options, at the bottom of the panel. The More Options dialog box opens.

Select the appropriate options to format the visualization, as described above.

When finished, click Save to apply your changes.