MultiPass Aggregation for a calculation

Pietro Poli

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?

Phil Taylor

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