Version

Grid View

The grid view is the default visualization option for displaying data which presents the information in a matrix. You can resize the width of a column in the grid just by clicking on the grid header, which will highlight the column in the grid, and then dragging the resize handle in the column header. Slide it left or right to modify the column’s width.

pivoteditorviewgridview_android
Note

Note: The grid view is suitable in a dashboard when the number of rows and columns is less than 10. When you’re dealing with small amounts of data, the preferred approach may be to "just show the numbers".

Column Sorting in View Mode

The grid view allows you to change the sorting of your columns (ascending or descending) in view mode . You can do so by tapping the arrows icon next to the column name.

GridViewSortingColumns_Android

You can apply more than one sorting criteria; you will see small number icons appear next to the existing column headers. The direction of the arrow will help you determine whether you applied ascending or descending sorting in previous columns.

SortingViewMode_Numbers_Android

You can also choose to remove any existing sorting options you have entered with the "None" or "Clear All" options. If any other sorting options remain, the order in which they will be applied will be determined by the number next to the column header.

SortingViewMode_Remove_Android

Conditional Formatting

The grid view, among other views, allows you to provide different formatting of the cell depending on the values found in a numeric column. For instance, values in the lower 50% range of a grid can be colored in red, the higher 80% in green, and the mid-range ones with yellow.

PivotEditorViewGridCondFormatting_android

The conditional formatting must be applied when the dashboard is created in iOS or Desktop, before importing it to Web.