Project Status Over Time Graph

English Forum Product Feedback
,
1

I am trying to find a way of reporting on a project status over time.

I want the bottom to be months and then the stacked bar to show how many were off track, on track and at risk.

Is there any work around for this?

2

I don’t think you can, and I don’t think Asana has anything that allows you to track data over time. It’s been missing, and there are many cases where we hoped it existed, but I think it doesn’t yet.

1 Like
3

@Danni_VanguardCC I like the idea. Voted!

image
image425Ă—426 14.8 KB

What I’d do:

  • export a CSV of a portfolio and put the export date in the name: YYYY-MM-DD.csv
  • Setup PowerQuery (or something similar) to combine the data and visualise over time (refreshing Excel to add data from all files in the data folder)
  • Find a way to automate the CSV export, likely with API.

Maybe there are other ways using API to get data over an entire instance (if that is your use case?) but I’m not sure.

Curious to hear @Bryan_TeamKickstart’s and @Phil_Seeman’s toughts.

There are some dashboard tab options, like task completion over time. But I agree this is quite limited.

4

@Jan-Rienk - thanks for the @mention.

@Danni_VanguardCC - Three options – none is simple, but all are possible.

  1. Recurring Task + AI Rule (to summarize the tasks in the project (only works if there are less than 200 tasks edited that month in that project) + Reporting project (or custom fields used just for reporting).
    You could set a recurring task to recur every last day of the month at 11:59 PM on recurring settings of “Monthly” > “Last Day”.
    Put it in a section called “Automated Reporting Tasks” or something similar. Create a Rule w/ AI Studio and instruct it to assess all open/recently completed tasks (supports up to 200 tasks per project) and check for/tally totals of “On Track”, “Off Track”, “At Risk” (however you define these, either with a custom field, or a set of criteria).
    Then create your Asana dashboard widget and base it on the number fields that your AI rule has populated. Not simple or straightforward to set up, but it works. Did something similar with another Asana client. (We can help you do this for free)
  2. Set up a Zapier or Make.com automation to do the same actions as the option above. (We can do this option too as a paid service, but I just recommend doing the free version above)
  3. Or, if you are on Enterprise, you can use a Script Action in Asana to do this. (We can do this option too as a paid service, but I just recommend doing the free version above)

So, nothing native out of the box, but definitely doable.
If you need help doing any of these, please feel free to reach out. We can review my response above and either quickly build the Asana-native option (#1), or discuss options for helping you as a one-time deliverable or ongoing Asana customization help. But, honestly, I don’t think you need that. We could probably build this together in 15 mins. (https://kstart.io/quick-help)

2 Likes