Screenful update: Introducing Table chart with custom formulas for Asana

Hi, folks. Today I’m very excited to share something cool with you:

You can now use a new chart type in Reports by Screenful. The new Table chart allows to view data in rows and columns. You can choose how your data is grouped into rows, and you can configure the columns to display exactly the information you need.

Here’s an example of a Table chart:

It is similar to a Pivot table as it aggregates the task data into sums, averages, and other statistics. It allows analyzing large amounts of task data in different ways rapidly. For example, you can track key metrics such as velocity and cycle times across your boards.

What makes this chart really powerful is that you can have as many columns as you want and configure them separately.

Adding a calculated column

The calculated column is a special type of column that displays data computed based on the other columns’ data. 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 mathematical formula .

In this example, the formula entered is

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

It means 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 on the green 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 of 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:

Summary

Table chart is now available for all users . With the Table chart, you can create progress lists for your projects, epics, team members, or whatever it is that you want to track. With configurable columns and support for formulas, it allows great flexibility.

To give it a try with your own data, sign up for a free 21-day trial.

As always, we’d love to hear from you. Please do not hesitate to contact us any time at hello@screenful.com if you have questions or feedback.

Have a productive week!

4 Likes