About Simple Table Widgets
Field Type Compatibility
The simple table widget is compatible with the following field types:
Only fields with the above type will be available when selecting the rows for the simple table widget.
Simple tables can be configured in a lot of different ways – it’s all dependent on your data visualization needs. Here we’ll cover the primary fields you can fill out to start displaying data in your widget.
- Click Add Metric to add a metric (or multiple metrics) to your simple table.
Qtip: You have many different metrics to choose from, including count (number of responses), average, sum, maximum, minimum, and more. To learn more about what each metric means and how to configure them, see Widget Metrics.Qtip: If you add multiple metrics, you won’t be able to add a column breakout, since the columns of your table will be broken out by the different metrics you’ve added.
- Click Set Row Dimension to break out your rows by another field.
Example: If we add department as a row dimension, we can see average CSAT by each department, instead of just one average CSAT value for all the data in the dashboard.
- If you have only one metric in your table, you can click Set Column Dimension to determine the breakout for the columns. That means there will be a column for each possible value of the field you choose, and the metric will be the calculated value for each row and column.
Example: This table shows average CSAT per department per year. So we can see the CSAT for Marketing in 2018 was 4.3, in 2019 was 3.1, and so on.
Qtip: When selecting a metric, every metric except count will need a field specified. Only a field with the type Number Set or Multi-Answer Text Set will be available. For more on metric options and filters, see Widget Metrics.
Include empty responses
When you select Include empty responses, you will show rows of your table even when a given response or row of data has no information for any of the fields you’ve added to the table.
This setting can be found under “Display Options.”
Clicking Add Calculation under the selected rows adds a calculation column to the table. The default calculation is sum. Sum displays the total for each column in the Sum row. Clicking the calculation box allows you to pick a different aggregate function. The available calculations are: sum, average, maximum, and minimum.
Adding formatting rules to your metric allows you to specify how values in a certain range are formatted on the Simple table. This is useful if you would like to be able to easily differentiate cells on the table based on their value. To access formatting rules:
- Click the desired metric.
- Select the Options tab at the top of the metric window.
- Click Edit Rules under Formatting Rules.
- Click Add Rule to add a new formatting rule.
- Configure your rule. Use the A button to specify the formatting you’d like to apply. Select a condition from the dropdown and enter a numeric value in the entry box.
- Use the + sign to add additional formatting rules and the – sign to delete rules.
Dashboards can help you understand whether the differences you see over time or between groups are statistically significant, and therefore worthy of driving important business decisions. With significance testing in simple line charts and simple tables, you can discover what data changes matter most.
See Significance Testing in Simple Charts & Simple Tables (CX) for more information.
Rolling calculations are a means of applying a metric over a set of data points composed of multiple periods. The rolling calculations options are rolling averages and rolling metrics.
See Rolling Calculations in Widget Metrics for more information.