[From Wrike] Multi-Pass Aggregation in Wrike Analyze
Épinglée En avant- Determine the “lowest” ID level to use for aggregation (in the example above, Timelog ID).
- Remove the SUM function if it is used as the type of the numeric values and use MAX, AVERAGE, MEDIAN, or MIN instead.
Example: if you're using [Total Timelog Time Spent (minutes)], replace SUM with another aggregator:
- If the type is "All items", replace SUM with the aggregator.
Example: if instead of [Total Timelog Time Spent (minutes)] it was SUM(Timelog Time Spent (minutes)] used, replace it with MAX, AVERAGE, MEDIAN, or MIN. - Use SUM to aggregate on the ID level. Since every ID is unique, this prevents duplicates from being included in the calculation.
Example: (sum([Timelog ID], max([Timelog Time Spent (minutes)])))/60
Katsiaryna S Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Katsiaryna S Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Thank you for sharing this Katsiaryna S.
I will keep this in mind for the future.
I found very helpful your reference to Using DDIFF: On-Time Compliance SLA Tracking from Sam Alter, which is a very good improvement for my time adherence reports
Rohan V Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Rohan V Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online