Alternative Grid type. Supports formatting, conditional highlighting, sorting, grouping, and search. Also supports Excel downloads, sparkline charts within cells, and has a different look and feel than the basic grid type.
| Data Grid 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 | Calculate statistics: min, max, average, total, count, and weighted average. Can be displayed at 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 |
| First Page Limit |
Allows you to set the number of records to load on the first page of Data Grid widget. Default is 1000 records |
| Parent-Child - Parent Column | If you wish to display data where you have a parent child relationship, and where a parent key is defined wish to put all the items under that parent |
| Parent-Child - Key Column | If you wish to display data where you have a parent child relationship, and where a parent key is defined wish to put all the items under that parent. Use this to define which field the accordion will apply on |
| Parent-Child - Collapse Rows | Use this to display child rows collapsed by default |
Creating Sparklines: To create a sparkline within a chart your data must first be in array format.
If your data is not in array format, you can use the ARRAY() function in Cloud9QL. You can add an array function via Settings > Data Transformation > Add Function.
In the examples below, we have illustrated adding the array formats for six different visualizations including line, area, bar, spine, and more.
Click on the +Add Function button to add an array format for a line visualization.
Click on the +Add Function button to add an array format for an area visualization.
Click on the +Add Function button to add an array format for a bar visualization.
Click on the +Add Function button to add an array format for spine visualization.
Click on the +Add Function button to add an array format for spine area visualization.
Click on the +Add Function button to add an array format for a pie visualization.
Once your data is in array format you can turn your data into a sparklines via settings.