MultiPass Aggregation for a calculation
Hi!
I'm working on a new Wrike Analyze report.
I need to show the time (effort and timespent) for all tasks created and completed in a small lag of time. For example a Week.
So I'm working on three different Values in Pivot Table.
- Effort
sum([Task ID],[Min Task Effort (minutes)])/60
- Timespent
sum([Task ID],[Min Timelog Time Spent (minutes)])/60
And all is ok.
Now I need to calculate Date Difference between Created Date and Due Date, so I added a new value
DDiff([Days in Task Creation Date],[Days in Task Due Date])
And I need to filter only values between 0 and 5 days.
When I add filter and this DDIFF all my data (Effort and Timelogs) become inconsistent.
For example a task with 1h of TimeSpent become 5h.
What I'm missing?
Hi Pietro Poli you're way more experienced at this than me, but I've often had problems with specifying SUM(x,y) - I've always specified the type of calculation in the expression itself - e.g. clicking on the blue text and selecting the relevant type.
Just a thought :)
Thanks Phil Taylor,
it makes me crazy 🤯🤯