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.
|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.