About Simple Table Widgets
The Simple Table widget organizes data into a table with one or more metrics as columns and the values of a field from the dataset as rows.
Qtip: If you have multiple sources mapped, all source data will be displayed in the widget together. You will need to use a widget-level filter to ensure only one data source is displayed at a time. You can even lock this filter, if you don’t want dashboard users to adjust it.
Field Type Compatibility
- Number Set
- Numeric Value
Only fields with the following types will be available when selecting the Rows for the Simple Table widget:
- Number Set
- Text Set
- Multi-Answer Text Set
For basic widget instructions and customization, visit the Widgets Overview support page. Continue reading for widget-specific customization.
When setting up a Simple Table widget, you will need to specify at least one Metric and your Row Dimension. To add additional columns, you will want to add multiple metrics, which will then cause Metrics to display as the Column Dimension.
When selecting your Metric, you will need to give your metric a Label (i.e., a name) and choose the metric itself. If you choose a metric other than Count, you will need to specify the field that the metric will be calculated off of.
Your available metrics include:
- Count: Display response counts from the selected fields (i.e., number of respondents choosing a value in a five-point scale)
- Average: Exhibit the average value for a selected field.
- Minimum: Show the minimum value of a selected field.
- Maximum: Present the maximum value for a selected field.
- Sum: Pull in the sum of all values for a selected field.
- Net Promoter Score: Identify the Detractors, Passives, and Promoters from NPS questions.
- Correlation: Input Pearson’s r value for the correlation between two fields.
- Top Box / Bottom Box: Display the percentage of responses that fall into a specified range of values.
- Subset Ratio Metric: The number of people who selected a specific choice divided by the number of respondents. It can be used when you are looking to visualize a proportion. See Subset Ratio Metric for more information.
Qtip: This metric is available on the simple chart and simple table widgets. If you are creating a proportion field for these widgets, we recommend using the subset ratio metric.Example: Let’s imagine that your organization allows employees the option to work from home. With the subset ratio metric, you can now calculate what proportion of your organization would choose to work from home and compare it to the proportion of employees who would like to work in the office.
- Benchmarks: Any benchmarks you’ve created.
You can also select Options to specify whether you would like to show the value as the Metric Value or the Metric value / Total, whether or not you would like your metric in a Number, Percent, or Currency format, as well as the number of decimal places you would like displayed.
In addition, you can select Filters to add a filter to your widget on the metric level. These filters are set up similarly to the ones that you set up in your dashboard.
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.