Did you hear folks?!?!
A universal reporting tab is out now with Asana. So you can product charts combining the joys from all your projects and portfolios in one go. Why? Because to progress with factual based decisions, you need clarity⊠and clarity can only come when you have a one stop shop for the health of your workload.
Letâs dive into few things with this feature:
Creating a dashboard is dead easy. Simply click on the tab and start playing with the charts.
Note: if you want to delete a dashboard, you need to edit it and then select the delete button. You are unable to delete it from the landing page. Something worth considering.
Create all the charts you need and then start thinking of the layout. Why? because if you have only 3 charts, the layout will fill itself up row by row. You cannot keep the first row with one chart and move to the second row. At least I did not figure out how to.
When you are planning your dashboard, allow for some time to think of what info you want to share.
Start slow. At the moment, there is no option to duplicate a report after creating it. So do not let the excitement run wild with creating so many options that you will not refer to in the future. I personally would like the option to duplicate from these 3 dots.
So what scenarios would you need to have such dashboard ready:
â”Overview of multiple projects for the same team and the breakdown of:
their task count
their task status
their progress - or any custom field you have designed in common for both projects
â¶Do you track time or financials? you can report on numbers of a project or a portfolio
â·Showing the workload of the team and helping ease the pressures from the busiest - most assigned individuals - such reports bring on the visibility and opens the discussion
And remember, delivering a message is far more clearer when visuals are used. So let the simple visuals here aid you rather than just talking at your audience.
Have you start playing with universal reporting yet? what are your takes on it? and what are the first chart types you started using??
of course you can read all about it at the blog here:
Cool. I think itâs a nice start, but unfortunately falls short for us. Hereâs why:
We need to estimate workload, per client (tracked by a custom number column in all projects) for each upcoming month. For example, Client X gets 100 hours per month of our teams time. We schedule projects and tasks with time estimates and need a way to see the estimated total for the upcoming month. Pretty straightforward, yes? Unfortunately, Universal Reporting canât do it, because:
UR canât filter projects in/out (like you can in advance search) - This would allow us to sum up estimates per client.
UR canât filter by ânext monthâ, whatever ânext monthâ is. I.e. Itâs currently June, so next month is July. It can only filter by relative time which basically means the calculation is useless for us for this use case.
UR (or advanced search) canât extrapolate numbers proportionate to task timelines. I.e. Task A is scheduled from May 29th - June 2nd (5 days) and is estimated to take 10 hours (custom number column). Simple math 10 hours / 5 days = 2 hours per day. So if the ability to filter by âNext Monthâ is ever added, I need Asana to be able to do this calculation so that the report would show 6 hours for May and 4 hours for June.
I donât mean to rain on the parade and I am planning on digging deeper into this new feature to see if there are other parts of our business in which it could be useful, but the main thing I was hoping it could do, it canât so Iâm posting it here in hopes that the use case resonates and it could be added.
You have mentioned some really valid user cases for the usability of this feature.
I think for me, I approach these new features in a slightly different mindset.
As it is the first release, does it give a level of visibility that I could not get before which made me create my own reports? If the answer is yes, then I am already on a winning journey.
Point 1 - I did not understand what you meant by projects in/out - if you can share a bit more, I can look at it and see if I have something similar I work with.
Point 2 and Point 3 are brilliant requirements and would be of such added value for the feature. I would suggest creating separate product feedback so we can start tracking voting and more user cases on it to provide to Asana.
And do not worry about my parade, it takes a lot for it to rain on it Thanks for providing your user cases
Great question, and the answer is yes!
Once you decide on the main factor of the chart, click next, scroll to the bottom and you can add a filter.
You can select subtasks as a filter. On the same page where you can select this filter you can decide on the date range you want to show: for example: incomplete for the next 6 weeks or so.
Thanks so much for this! I am however, having a second issue. When I try to look at all of my complete tasks, they stop in July 2020. There is no recent data. Do you know why that would happen?
Hi Brian! I may be misunderstanding here, but wanted to give it a shot - have you used the Workload view in Portfolios? It sounds like the agency I work for has a similar use case to yours - We currently assign out projects a month in advance and do so by assigning hours per task/ per assignee and then hop over to the Workload view to see how each individualâs bandwidth appears (we have some cases where we view it based on select clients/ projects and another case where we view an overall âglobalâ Portfolio that includes ALL work estimated so we can be sure that individuals that work on multiple clients arenât accidentally scheduled to work more than 8 hours per day/ 40 hours per week).
would it be possible to add a scroll to the right feature for charts that contain more X-axis fields than what is visible. Currently there is a â+19 moreâ Options but this takes you to a huge list which impossible to use.
Use case: We have lots of clients projects. We have created a reports to see projects with outstanding tasks. We can only see the 1st 12.
Also loving the colours but could you add a splash of colour to the number reports. The fade away in to the background. As a work around we are using Doughnut with a single filter.
Thanks for your feedback, @Victoria_Schupp! We donât have immediate plans to add tags to Charts in Dashboards, we usually recommend custom fields for your reports. In the meantime, you can upvote for this feature here: Dashboard/report tasks by tag in a project We will share any updates in that thread if we have news in the future!
Hi @Rashad_Issa - You mentioned in scenario ⥠above - tracking time and that we can report on numbers of a project or portfolio.
Iâm trying to grab the information that I can get from workload view of the capacity of a person and create a report in my dashboard that will have a 30, 60, and 90 day view ahead.
I can grab hours, but is there a way to show how that compares to capacity as we see in the workoad view?
This is a very valid point. At this stage, and to my own understanding, the only way you can reflect the capacity in the reporting feature is by using the pre-built resourcing charts.
I will try and play around with the set up of new charts and see what I can come up with. But my initial feeling is that this is a feature that would require development.
One of the areas Asana should be working on, is the availability of different types of reports in different areas with the platform. I have requested a dev feature here: Integrating Project Dashboards with Project Status
But will certainly test and see if I can come up with any workaround for your request and will let you know if I were successful.
This exact comment right here brought me into the forum today. I desperately need to see the â+29 moreâ projects to the invisible right side of the chart. I mean, well done guys, but this right here, câmon. This needs to be fixed fast.
Huge limitation for businesses with lots of clientâs projects. Data driven insights arenât complete without being able to view the entire options in the chart.
Hi! Iâm new to Asana premium. Seeking guidance on how to create an advanced search for all tasks in an organization (all projects) sorted by assignee by project. I took a quick shot, and finding that not all projects are delineated in the project field.
Hello @Judy_Whitehead unless I am missing something, this is a very simple task. just go to reporting, and create a new dashboard and select the chart type you wish and do not select any project, add a filter for subtasks, and you will get the report you need.