Note: A separate detailed ‘Grid usage document’ is available

Grid Chart

The Vitara grid is the easiest to use grid. With a single click, we can access an infinite number of options. Grid formatting is provided at both the column and row levels, as well as appealing grid themes, the ability to group (Page by) at many levels, metric aggregations (Subtotals) at various grouping levels, column grouping, thresholds with custom icons, and many other features.

Inputs

Metrics: 1 metric Attributes: At least 1 attribute Add as Filter Option - Available

grid inputs

Using the Vitara grid chart it’s so easy to apply the following options.

Grouping

We can apply to the group, both at column level and row level. Expand/collapse grouping. For group headlines, we can apply aggregations. Further, we can show grand totals for grouped metric aggregated headlines.

Aggregations

We can show aggregations (Subtotals) on groupings. Enable or disable grand totals.

Thresholds

Apply/remove thresholds easily. In thresholds, we can set the background color, text color, icons, icon color, icon size, icon only and use custom images as icons.

Sorting

The column data can be sorted in either ascending or descending order with only one click on the column header. Data will be sorted in ascending order on the first click, descending order on the second click, and sorting on a column will be removed on the third click. There is also a “Clear Sorting” tab that will reverse the sorting that has been performed to every grid column.

Look and feel

Auto size fit to the content/ fit to grid width, grid themes, set grid row height, option for clear sorting/clear threshold/clear grouping/clear filter, export grid data into CSV format, pin a column to the right/left side. Text font properties like font style, font size, alignment, text color, bold, underline and italic are available for column headers and body text.

Filters

View filters can be created specifically to the grid i.e filter on attribute or metric.

Show/hide the number of children in a row group:

Grid has the ability to show or hide the number of children in a row group. The number of children in a row group can be shown or hidden in grid charts. Click the ‘Edit’ button, then select ‘Grid Theme’ and check the ‘Hide Children Count’ checkbox in the properties popup window.

grid showhide child count