Note: A separate detailed ‘Grid and MicroChart usage document’ is available
Vitara grid is the most user-friendly grid. We can explore so many features with just a click. Grid formatting is available at both at column level and row level, attractive grid themes, apply to group (Page by) at multiple levels, metric aggregations (Subtotals) at different grouping levels, column grouping, thresholds with custom icons, and many more.
Metrics: 1 metric Attributes: At least 1 attribute Use as Filter Option - Available
Using the Vitara grid chart it’s so easy to apply the following options.
By default grid chart will show ‘Grand Total’ for all the metrics in the chart. To disable/hide ‘Grand Totals’ click on the ‘Edit’ button select the ‘Grand Totals’ tab then expand the ‘Visibility’ dropdown button to select the ‘hide’ option. Please refer the below screenshot.
Starting from 4.1 release we can make the ‘Grand Totals’ row to display on the top of the grid or at the bottom of the grid. Click on the ‘Edit’ button to open the properties window then select the ‘Grand Totals’ tab and expand the dropdown button ‘Position’ to select the ‘Top/Bottom’ option. Please refer the below screenshot.
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.
We can show aggregations (Subtotals) on groupings. Enable or disable grand totals.
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.
With just a click on the column header will sort the column data in ascending or descending order. On the first click data will be sorted in ascending order, the second click will sort in descending order and the third click will remove sorting on a column. ‘Clear sorting’ tab also available which will clear sorting applied on all columns in the grid.
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.
View filters can be created specifically to the grid i.e filter on attribute or metric.
In 3.8 release Grid/Micro chart introduced an option to show or hide the number of children in a row group. Grid/Micro charts have an option to show or hide the number of children in a row group. Click on the ‘Edit’ button, in properties popup window select ‘Grid Theme’ and check the ‘Hide Children Count’ checkbox.