Need dashboard report in Portfolios to track total days of delay across tasks. Dashboard 'Total Overdue Tasks' chart shows task count only, not cumulative overdue days.

Asana Community Product Ideas
1

Hello - we are a national nonprofit organization with over 120 national staff. I lead our Project Management Office for our complex, cross functional multi-level portfolio of projects and initiatives. We need help with reporting on overdue task duration in Asana Portfolios. The ‘Total Overdue Tasks’ dashboard chart only displays the count of overdue tasks, not the cumulative number of overdue days. We attempted to create a custom formula field (Completed at - Due date) to calculate delay duration and report it in a dashboard, but this approach is not working as expected. Asana confirmed that this feature does not exist. There are several clunky workarounds but are not working for us. Because this is not available in Asana currently, we are requesting that Asana create report(s) showing total days of delay across tasks in Portfolios. This is blocking and delaying our work and reporting with Senior Leadership. This is High priority for us as our KPI’s are:

Dashboard KPIs for Task Status in Portfolios
Dashboard KPIs for Task Status in Portfolios1170×519 27.9 KB

Column 1 Column 2 Column 3 Column 4 E
KPI Why It Matters Asana Report Widget available NOTES
Total Overdue Tasks Volume of slippage Available Using this metric/KPI
Total Days Overdue Severity of slippage Not Available In Asana dashboards, the built-in “Total Overdue Tasks” chart only shows the count of overdue tasks — not the cumulative number of overdue days across tasks. Asana does not currently provide a native dashboard metric for these??
“Total days overdue”
“Average days delayed”
“Sum of overdue duration”
Avg Days Overdue Trend/performance indicator Not Available In Asana dashboards, the built-in “Total Overdue Tasks” chart only shows the count of overdue tasks — not the cumulative number of overdue days across tasks. Asana does not currently provide a native dashboard metric for these??
“Total days overdue”
“Average days delayed”
“Sum of overdue duration”
2

@Hillary_Bardwell This is definitely doable, but it would require exporting the data to report on it. How many different ways are you looking to segment this data? Is it just in aggregate? Or are you looking to slice it by:

  • portfolio
  • assignee
  • project
  • etc?

If it’s purely aggregate, you might be able to get away with an Excel/sheets export and a pivot table template. If you want to be able to segment/filter by more criteria, then it would need to export to a database and be a small data project. Once it was set up, it could be completely automated to give you that reporting you’re looking for and probably additional insights.

3

@Nathan9 - thanks. We are already doing that - exporting data to excel and using pivot tables. We are doing at portfolio and project level. We are looking to and requesting of our Asana account manager(s) for more segmentation capabilities directly in Asana in the dashboards without having to export it.

4

Sounds like you’re on the right track for the external reporting through Excel. We build custom reporting dashboards for clients and often they need to pull in Asana data automatically.

Even if you execute it yourself internally, I’m happy to talk through it with you on Zoom sometime if that’s helpful.