I have a field called Status2 with options for what stager the task is at and I’d like to chart an average of how long tasks live in each option of Status2. when i go to select time in custom field, Status2 doesn’t show as an option. what am i missing?
Interesting. And if the x-axis is changed to something else, can you pick that field?
Hey @jeremy_webb1, what an interesting question.
I have a thought on why this is happening - from what I’m seeing the Status 2 is a multi select custom field and currently those aren’t going to appear within the Time option in the chart for the Y-axis.
Some workarounds I can think of are:
- Using the Progress custom field type instead, which does support time tracking in reports
- Using the Asana API with a third-party integration to track these status changes
- Exploring Asana partners like Velocity that specialise in time tracking metrics
Another thing I can recommend is posting this in the Product Feedback category where it can be properly tracked and considered for future development.
Stefan, thanks so much for that insight.
Can you expand a bit more on what you mean by Progress custom field type? I’m not seeing that option when i go to add a custom field
I checked in with Velocity and it sounds like they aren’t able to provide this data.
I had an idea - what if I setup another custom field (call it “Status Tracking”) that has the main statuses that I want to track from Status2, but set it up as a single-select field with a subset of options from Status2. Then have a rule setup that when certain Status2 options are chosen, the rule sets the Status Tracking field to the appropriate field (ie inbox, wip, waiting on feedback, delivered). then would i be able to track time in Status Tracking options?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.