Basic Grid. Supports formatting, conditional highlighting, sorting, grouping, and search. Has a different look and feel to other Grid type.
| Data Grid- Basic: | |
| Primary Use: | Display the data in numerical form on a simple, easy to read grid |
| How to use: | Click on a visualization that has been already created/formatted, change the type to "data grid" |
| Hyperlink Support: |
Hyperlinks are created using the concat function within Cloud9QL and column names may be passed in as parameters to For example: |
| Specific options: | |
| Title Font Color | To set the title font color of widget |
| Title Font Size | To set the title font size of widget |
| Font size | Size of the fonts for the header and rows |
| Font color | Font color of the rows |
| Color of odd rows | Background color for each odd rows |
| Color of even rows | Background color for each even rows |
| Color of Header rows | Background color for the header |
| Header font color | Font color for the header |
| Minimum Column Width | For cases with large number of columns, apply a minimum grid width to enable horizontal scroll instead of fitting the grid into the viewport |
| Grid line thickness | Adjust the thickness of grid lines |
| Cells Padding | Pad cell content |
| Row height | Height of each row in the grid |
| Format | Formatting for one or more fields |
| Reset Column Width | To reset the width of each column |
Time format for data grid: Time format with date is available in Format option of the data grid. When you format cells with date format, you can select the date with time formatting.