Analyze Widgets and Effort Distribution

Attempting to create a Pivot Table widget in Analyze that displays effort per month associated with a project. Basically a Pivot version of a workload chart. Goal is to have a reliable projection of upcoming effort over the length of the project/contract. I just can't wrap my head around how to display/calculate the distribution of those hours over the duration of the task within the widget. As it stands, it is displaying the total effort value in the month of the task's start date.

e.g. In the image above, column of 7/2022, the task that is contributing that 48 value spans 12 months...but it only displays the lump some of hours based on the start date of the task. I would like it to display 4 hours every month.

It's either the field I am using for the columns, the effort per month value, or a combination of both. I believe updates to those two fields and some trick formulas should get me where I need to be, I just need a nudge in the right direction. Any help is appreciated. Thanks!

3
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
5 commenti

We don't have Analyze yet - so I don't have a specific or verifiable answer for you - but in general, with relation to effort data - perhaps it would help to use flexible effort allocation to spread the values across the timeframes you are looking for?

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Jake Yohn, I agree with Sherrie Besecker about Flexible Effort. 

Looking at your view you are showing data by month, have you tried by day? I have noticed that Wrike Analyze gives me better information when my formula's specify days.

Another thought, have you tried a regular report with formulas?

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Sherrie Besecker we definitely utilize the flexible effort mode when assessing capacity in the workload view, which is very helpful. That is the frustrating part, as Wrike does have the functionality to process the total effort value and extrapolate said value over the duration of the task per day in workload, but when you attempt to recreate that in analyze in a table format, the fields currently available don't appear to allow that.

Kevin Thalacker May have to give the days a try as opposed to month, will just need to find a way to display a subtotal for the month. 

For a bit more context, we have power-users that are comfortable gathering information for a project from multiple areas of Wrike, e.g. a regular report for hours, workload for monthly projections, etc. But we are looking at aggregating all of these reports into Analyze as an overview for project stakeholders who do not have that access. That's one of the main reasons we jumped for the Analyze functionality.

Thank you both for the suggestions!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Jake Yohn I'm with you on this - I'm trying to spot trends by all I can see are by day views. I would love to find a way to see monthly stats. 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Jake Yohn - I was able to do this within Wrike Analyze, and validated that I have the same values month by month as I see in the workload view. I can also choose by quarter or year. Is this what you're looking for?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Analyze Widgets and Effort Distribution
[this list is visible for admins and agents only]

Su
Didn’t find what you were looking for? Write new post