A table question lets you design your own table inside a custom metric, with each quantity column reported as its own metric. Available to fund managers and standalone companies, from Setup → Custom metrics.
What is a table question?
Some data doesn't fit a single answer box. Waste is reported by stream, energy by meter, travel by trip. Until now, a custom metric could only ask for one value per question, so you had to create a separate question for every row you expected.
A table question lets you design your own table inside a custom metric. You choose the columns, and the person filling it in adds as many rows as they need. Each quantity column becomes a metric of its own, totalled across the rows, so you can report on it, export it and use it in calculated metrics in the same way as any other custom metric.
Table questions are available to fund managers and standalone companies, in Setup → Custom metrics.
Before you begin
You need a custom metric group. Table questions are added to a simple metric inside a metric group, in Setup → Custom metrics. If you haven't created one yet, see Creating custom metrics (link to be added).
Every table needs at least one quantity column. Quantity columns are what turn the table's answers into reportable metrics, so a table with only text, multiple choice or yes/no columns can't be saved.
How to add a table question
Go to Setup → Custom metrics to open the Custom Metric Manager. Select the metric group you want to add the table to, or click Add metric group to create a new one.
Click Add simple metric, or open an existing simple metric to edit it.
Fill in the data point details as usual, then under the question, set Question type to Table.
When a question is set to Table, the question box widens so more columns are visible without scrolling.
Add your first column. For each column, enter a name and choose its type:
Text — free text, e.g. a description or a supplier name
Quantity — a number with a unit of measure, e.g. Kg, kWh or %. Each quantity column becomes its own metric
Yes/No — a simple yes or no answer
Multiple choice — one option from a list you define, e.g. a waste stream or a region
Switch Required in every row to Yes on any column that must be filled in on every row.
Add as many further columns as you need. Once a column is added, you can drag it to reorder it among the other columns.
Click Save metric.
Once the metric group is in a data request, the people filling it in will see the table on the data point.
Filling in a table
The person filling in the data adds one row per item. They can add or remove rows as needed before submitting.
Any column marked Required in every row must be filled in on every row before the data point can be submitted.
Rows that are completely empty are removed when the data is saved, so the empty starter row isn't stored.
If a blank row is added after rows that have already been filled in, submitting still validates any required cells in that blank row. Remove unused blank rows before submitting, or save the data point as a draft first, then submit.
Custom tables can also be filled in through the Excel template upload and the Import option on the data point, in the same way as built-in tables. The template includes your table's current columns and multiple choice options.
Users can also bulk upload data for their custom metric tables, as you would for any other metrics.
How table answers appear in reports
Each quantity column in your table becomes its own metric, named as "Question title - Column name". This naming is used in reports and in the raw Excel export.
When a table is answered, the rows are combined into a single value for each quantity column:
Quantity columns are added together across all rows.
Percentage (%) columns are averaged across all rows.
Currently, only quantity columns create metrics. Text, multiple choice and yes/no columns are kept with each row, so you can still see them in the drill-down and in Raw Activities, but they don't appear as metrics of their own in reports.
Example
You set up a table question called Community investment by project with four columns: Project type (multiple choice), Investment (quantity, GBP), Local workforce (quantity, %) and Notes (text). A company fills it in like this:
Project type | Investment (GBP) | Local workforce (%) | Notes |
Education | 15,000 | 80 | Scholarship programme |
Health | 25,000 | 60 | Clinic build |
Environment | 10,000 | 100 | Reforestation |
In reports and the Excel export, this table produces two metrics:
Metric | Value | How it's calculated |
Community investment by project - Investment | 50,000 GBP | 15,000 + 25,000 + 10,000 |
Community investment by project - Local workforce | 80% | (80 + 60 + 100) / 3 |
Project type and Notes don't create metrics, but each row's values are shown when you drill into the reported figure and in Raw Activities.
Using table columns in calculated metrics
Quantity columns can be used in custom calculated metrics in the same way as other custom metrics. When you build a calculated metric, search for the column's name in Search metrics to insert it.
Percentage columns currently don't appear in this search. Search metrics includes number and currency metrics, which covers quantity columns, but excludes percentage metrics, so a percentage column from a table can't currently be inserted into a calculated metric. See Limitations and Best practices below for how to get a weighted percentage instead.
Changing a table after answers have been entered
Once a table has answers, some changes are locked to protect the data already collected:
You can add new columns.
You can't remove a column or change its type.
You can't change a quantity column's unit of measure (except columns using the # unit, which can still be changed, as with other quantity questions).
You can't switch a question to or from Table. To use a different question type, delete the question and add a new one.
If your metric group uses versions, changes made in a new version that would affect existing data, such as removing a column or changing its unit, are listed as breaking changes. You'll be asked to review and acknowledge them in the Confirm Breaking Changes dialog before saving. Answers already submitted against the previous version are kept.
Limitations
Currently, only quantity columns create metrics. Text, multiple choice and yes/no columns are stored with each row but aren't reported as metrics.
Percentage columns are a simple average of the rows. They aren't weighted by any other column. In the example above, the weighted share of waste diverted from landfill would be 70%, but the table reports 55%.
Percentage columns can't currently be selected in the calculated metric builder's Search metrics. Only quantity (number/currency) columns can be inserted into a calculated metric.
Multiple choice columns allow one option per row. Columns where several options can be chosen aren't supported.
An existing question can't be converted into a table.
FAQs
Why doesn't my text or multiple choice column appear in my report? Currently, only quantity columns create metrics. The values in other columns are kept with each row and can be seen in the drill-down and in Raw Activities.
How is a percentage column calculated? It's the average of the values in every row, with each row counting equally.
How many quantity columns can a table have? As many as you need. Each one becomes its own metric.
Can companies upload their table data from Excel? Yes. Custom tables work with the Excel template upload and the Import option on the data point, the same as built-in tables.
Why can't I change a column's unit? Answers have already been entered against that column. Changing the unit would make existing answers inconsistent, so it's locked. If your metric group uses versions, you can make the change in a new version.
I added a column after the data request went out. Will companies see it? Yes. New columns reach the companies that already have the data request.
Why can't I find a percentage column in Search metrics when building a calculated metric? Search metrics currently includes number and currency metrics, which covers quantity columns, but excludes percentage metrics. Percentage columns from a table aren't currently available to insert into a calculated metric.
I added a blank row by mistake and now I can't submit. What do I do? Remove unused blank rows before submitting. Alternatively, save the data point as a draft first, then submit.
Best practices
Plan your quantity columns first. They're what you'll report on, and their units can't be changed once answers are in.
Use a multiple choice column, rather than text, for anything you want to group or compare later, such as a waste stream or region.
Mark a column as Required in every row only if every row genuinely needs it.
You can reorder columns after adding them, so don't worry about getting the order exactly right the first time.
If you need a weighted percentage, don't average the row percentages. Collect the underlying quantities as two separate Quantity columns, a numerator and a denominator, over the same rows and period, then build the percentage as a calculated metric: 100 × (total numerator ÷ total denominator). For example, recycled tonnes ÷ total waste tonnes × 100, rather than averaging a per-row recycling rate.
If you have any further questions, please reach our team at support@keyesg.com





