How much time task has spent with custom tag in a certain status

[Olga_Kireeva]

Hi everyone!
We have an interesting case, and I am unable to find a solution. All I found was topic from a few years ago - and verdict was only to use Screenful. These topics were relevant (but too old):

Reporting: How long do tasks take?

Is there a way to generate a report for a project that tells you how long (on average) cards spend in a specific column? I want to track velocity and understand – if my board has say, 4 phases – how long each phase generally takes. I am not looking for time-tracking solutions.

Tracking progress of task across columns

In order to onboard our clients, we have created a single project with multiple columns for which we keep moving the task from one column to the next until the client goes live on our platform which is when we complete the task. My question is, can we build a report which can enable us to see when each task entered and left each column?

Tracking board columns changes

Hi @Fillipe, did you end up building something for this? I am looking for something similar and be great if you would be open to sharing anything you’ve built? Cheers!

track a date of movement in section

Hello! I’m trying to solve the issue of tracking a date when a task was moved to a section. data.modified_at is not what I’m looking for, I guess. So, the question is how to get logs of task movement between sections

So our case: our developers have cutom field with several values (eg Research, Dev, QA, Design etc). We would like to make a report about how much time a task spends in each status and then calculate average time in each status for project and time slot.
For example, to check what is the average time for QA stage for project X in January 2023.

What is the best option to make this? Are there any options except for Screenful? Maybe it could be delivered via Asana API?

We have Asana Premium, not Business, so we are not able to use native Asana time tracker for now.

[lpb]

Welcome, @Olga_Kireeva,

Does this not work for you? This is a dashboard chart in a project:

Note: This requires the Business or Enterprise plan.

Thanks,

Larry

[Olga_Kireeva]

Hi, thanks for advice, but it doesn’t work for us since Asana Premium doesn’t allow to choose time in Y-axis - it is only available for Asana Business