Shouting out to the Asana community to see if anyone has experience or a resolution to a reporting block.
I am part of a team running 2-week sprint periods, completing a number of tasks and needing to report on team achievement during that sprint period. I have a number of custom fields setup to track pieces of task attribution, such as:
- Priority
- Task type
- Assignee
- Sprint points (task size)
I have been experimenting extensively with both prompts within Asana AI, and manual/date and time triggered rules within AI Studio. The overview of the prompt breaks down to requesting alphabetised bullet lists for the above points, counting the number of times each value from the custom fields is used on tasks in a specific section of my project.
In Asana AI, the experience is an incomplete set of results, iterating by telling the model where it has made mistakes, it apologising and doing slightly better, before it finally arrives at the correct set of results after 5-8 iterations. This takes long enough that it is faster doing it manually.
In AI Studio, the rules all fail, for a number of reasons:
- Unable to create a comprehensive sprint report because I don’t have access to all tasks in the ‘Completed Tasks’ section
- Can only view tasks surfaced by a search, not as part of a whole project section
- I’m unable to complete this sprint report because I don’t have the ability to run an advanced search to retrieve all tasks and subtasks from the ‘Completed Tasks’ section
- I need you to @mention the project section you want to pull tasks from (as far as I can see, you can’t @mention project sections)
Has anyone out there been successful in automating the creation of reports on segments of project tasks please? All advice and suggestions gratefully received!