Analysis Grid - Formatting Data

You can format the appearance of the data in the Table by clicking a table column header and selecting Format and then the desired option:

These options allow you to apply, or remove, a variety of standard formats. For more information about these formats see Format Data.

Selecting No Format will clear previously-selected numeric or color formatting but not alignment.

The Percent of Total format applies a calculation that determines each data value's percentage of the summed values and displays it as a percent.

New for 14.2 When utilizing the Percent or Percent of Total formatting options you can further customize the decimal place by selecting Percent Decimal Places:

Both a number string value and an empty value is considered valid input. If the value is not a number, it will be ignored. An "empty" value will remove the setting, and decimal places will return to the default value, zero or two.

Enter the desired decimal place and select OK:

This setting is column-specific, meaning different columns with different percentage values can be customized to display different decimal places.

Two special format options insert visualizations right into the column:

Selecting the Bar Gauges option will produce a horizontal bar gauge within the column, as shown above. The actual data value will appear in a tooltip if you hover your mouse over the gauge. Selecting the Cell Colors option will display the column value using an imbedded Cell Color Slider, as shown above. You can drag the slider in the column header to customize the color ranges.

The Cell Colors feature has been changed to allow you to apply conditional colors:

Its previous functionality is now represented by a new Format menu item, Cell Color Slider, as shown above.

The menu's Cell Colors item now displays the pop-up dialog box shown above, where you can select data value ranges and cell background colors. New for 14.2 The Values field can be customized to match the boolean format.

New for 14.1 You can also format conditional colors on the group level by selecting the Group Level tab:

Previously established grouping is available in the Group drop-down menu. Choose your Group and Aggregate using the drop-down menus.

Enter a numeric value in the field on the left and assign a color to the Count by entering a Hex code or using the Color Picker:

Select OK to apply your changes.

Your Analysis Grid reflects the conditional colors applied to the cells, like below:

To utilize this feature you must have an aggregation defined at the group level.