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.
Display & Formatting
| 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 |
| Header Height | Height of header |
| Minimum Column Width | To enable horizontal scroll instead of fitting the grid into the viewport |
| Column Ordering | Column Ordering |
| Hide Column | To hide the column from the grid |
| Reset Column Width | Reset each column width to 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 |
| Aggregation on top | Check to show aggregation on top |
Widget Menu
| 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 Dashboard menu |
Advanced Configuration
| Field | Interpretation |
|---|---|
| Scroll Limit | Scroll paging; default is 1000 records |
| Internal Sparkline Charts | Allows you to create charts within cells to see trends |
| Change Dataset | Change to a different dataset |
| On Click Event Handler | Define custom javascript behavior when a point is clicked |
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.
Line Visualization: Click on the +Add Function button to add an array format for a line visualization.
Area Visualization: Click on the +Add Function button to add an array format for an area visualization.
Bar Visualization: Click on the +Add Function button to add an array format for a bar visualization.
Spline Visualization: Click on the +Add Function button to add an array format for spline visualization.
Spline Area Visualization: Click on the +Add Function button to add an array format for spline area visualization.
Pie 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 sparklines via settings.