Data Grid: | |
---|---|
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 select concat( "<a href='facebook.com/'",customer_id, " _target='blank'>",customer,"</a>") as Facebook |
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. |