Customize aggregation in reports: average Time Spent
Hi,
It would be really helpful if you could customize aggregation in reports. It looks to default the to sum for all columns.
Where it would be ideal for example to see an average for "Time spent" as total time spent is not helpful information but an average would be.
right now we need to export these reports to do the needed calculations, not ideal.
Hi Aaron McLaughlin, thanks for your post! 🙂
I changed the title a little bit so that it can be found more easily. Hope you don't mind!
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
This functionality would be very helpful! You can change the aggregation in the Table view but I feel that it needs to be part of the reporting functionality also.
Thank you for sharing this input, Ron Grover! If there are any changes here, I'll be sure to let you know.
Also, just noticed that calculated fields in reports does not take the sum of the end result of the formula. giving you a useless aggregated sum
I would like to be able to track average turnaround time of a project. I have "site build" as a custom field and created a report which shows number of days spent on site build per customer. But I would like to see an average. Previous posts on this topic have suggested extracting into an Excel file and calculating the average with formulas. I hope that is not still the answer?
Hi Dina Paglia! This is not currently available in Wrike, so we need more votes here - they will help our Product team understand the popularity of this idea. Please upvote the original post above if you haven't yet 👍
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
I also want the average of a calculated field displayed in a grouped view. The field I want to get the average from calculates the days spent in a task by subtracting created date of completed date.
Additionally to that it would be great to have a widget on a dashboard which displays the average as a KPI number.