Table charts are a great way to see all the data with no visualization. Here are a few tips and tricks on building and using tablecharts.
Building a Table Chart
To build a table chart, first log in to your Grow account and click Add Metric. Choose your data source, connect your data, and press continue.
In the Data tab, click on the chart type menu to view the list of charts, then click on Table near the bottom.
Selecting Your Data
For each column you want to see in your table, you will need to select each column as a data series. Under the Data Series header to the left, click Add Data button, then select the column header that you want to add to the table.
Please note that there is a limit of 35 columns when creating a table chart metric.
Formatting Your Data
There are the formatting options available.
- Alignment
- Text Wrapping
- Text color
- Text Background Fill
- Text Styles
- Display as links
- Conditional Formatting
You can also change the size of all of the text in the table chart. Click on the Display option under Settings at the bottom left and you can choose the text size.
If you have links in your table chart and you want to make them hyperlinks, expand each data series and check the Display values as links box. If the URLs point directly to an image, then those images will display in the table chart unless this box is checked.
Add Clickable HTML Links
If you have any URLs in your data, you can make them live links that you can click on from the dashboard.
Click the drop down arrow on the data series that includes the URL and check the 'Display values as links' box.
The links in that column are now live links.
Enable Filter Option
If you want to be able to filter on your table metric, you can check the Enable Filtering checkbox under Settings in the Display selection.
Enabling this will bring up a filter option at the top of your metric. You can then use this to search quickly through your table.