An alternative grid type that supports formatting, conditional highlighting, sorting, grouping, and search along with the ability to download formatted grid information in Excel format.
| Specific options: | |
| 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 the each odd rows |
| Color of even rows | Background color for the 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 |
| Grouping | Group data by parameters |
| Aggregation | Can calculate statistics: min, max, average, total, count, and weighted average. Able to be displayed as the top or bottom of the data grid. |
| Internal Sparkline Charts | Add Line, Area, Bar, Spline, Spline Area or Pie charts inside of the table |
Creating Sparklines: To create a sparkline within a chart your data must first be in array format. To create a column in array format, use ARRAY(<field>) in the Cloud9QL.
Once your data is in array format you can turn your data into a sparklines in settings.
