Basic Grid. Supports formatting, conditional highlighting, sorting, grouping, and search. It has a different look and feel to other Grid types.
| Field |
Interpretation |
| Title Font Color |
Set the title font color of the widget |
| Title Font Size |
The default title font size is 14px. |
| Font size |
To set the size of the font |
| Font color |
To set the color of the font |
| Grid line thickness |
Grid line thickness value |
| Cell Padding |
Padding of cell content |
| Data Format |
Formatting for one or more fields |
Column and Header Settings
| Field |
Interpretation |
| Header Background Color |
Defaults to dark blue |
| Header Font Color |
Defaults to black |
| Minimum Column Width |
To enable horizontal scroll instead of fitting the grid into the viewport |
| Column Ordering |
Column Ordering |
| Reset Column Width |
Reset each column width to the default |
Row Settings
| Field |
Interpretation |
| Color of Odd Rows |
Default to white |
| Color of Even Rows |
Default to white |
| Row Height |
The height of each row in the grid |
Aggregation and Grouping
| Field |
Interpretation |
| Aggregation |
Aggregation for group |
| Grouping |
Grouping by some parameters |
| Field |
Interpretation |
| Show Title |
Show Title on Widget |
| Analyze |
Show Analyze menu |
| Alerts |
Show Alert icon |
| Filters |
Show Filter icon |
| Drilldowns |
Show Drilldowns menu |
| Query |
Show Query menu |
| Data/Export |
Show Data/Export menu |
| Data Diagram |
Show Data Diagram |
| Share |
Show Share menu |
| Refresh |
Show Refresh menu |
| Maximize |
Show Maximize menu |
| Remove from Dashboard |
Show Remove from the Dashboard menu |
Advanced Configuration
| Field |
Interpretation |
| Change Dataset |
Change to a different dataset |
| On Click Event Handler |
Define custom javascript behavior when a point is clicked |
Time format for data grid: Time format with date is available in the Format option of the data grid. When you format cells with date format, you can select the date with time formatting.
