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.
- 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.