How to create a formula in the Table chart?

### How to create a formula in the Table chart?

The Table chart aggregates the task data into sums, averages, and other statistics. For example, you can track metrics such as velocity and cycle times, and drill in to see data at an individual task level.

Each column is configurable, and you can specify the contents of the column. You can also specify what is shown in the summary row at the bottom.

If you want to add a column that is a function of some other column, you can use the Calculated column.

The Table chart aggregates the task data into sums, averages, and other statistics. For example, you can track metrics such as velocity and cycle times, and drill in to see data at an individual task level.

Each column is configurable, and you can specify the contents of the column. You can also specify what is shown in the summary row at the bottom.

If you want to add a column that is a function of some other column, you can use the Calculated column.

The Table chart aggregates the task data into sums, averages, and other statistics. For example, you can track metrics such as velocity and cycle times, and drill in to see data at an individual task level.

Each column is configurable, and you can specify the contents of the column. You can also specify what is shown in the summary row at the bottom.

If you want to add a column that is a function of some other column, you can use the Calculated column.

Guide contents:

The calculated column is a special type of column that displays data that is computed based on the data in the other columns. To add a calculated column, click Edit chart and scroll down to the column definitions. Click Add calculated column. A modal is opened which allows entering a formula. In this example, the formula entered is

##### (DIVIDE( { 3 Tasks done }, { 1 Tasks total } ) )* 100

What it means is that the value in column 3 (Tasks done) is divided by the value in column 1 (Tasks total). The result should show the percentage of work completed.

While it may look complicated, you don’t really have to type it as you can click the buttons below the formula field, which provide shortcuts to the most commonly needed formulas. If you’re a power user looking for a more complicated formula, here’s a reference to all the supported formulas.

Once you’ve added the formula and saved the chart, the calculated column is added to the chart: Now the rightmost column shows the completion percentage based on the values in the Tasks total and Tasks done columns.

When you write a calculated column formula, it is automatically applied to the whole table and evaluated individually for each row.

### Formatting the calculated column

There are a couple of things you can do to spice up your calculated column. A more visual way of displaying percentages is by using progress bars. To change the representation, select Progress Bar (0-100) from the Format menu. You can also change the column header from the default “Calculated” to a more descriptive one in the Chart format section.

Finally, you can reorder the columns by drag and drop. In the below example, we’ve renamed the column header to Progress, and placed it as the first column in the chart. Here’s the final chart: 