aggr() on the basis of max updated_date

[#1]

Hi All,

Want to calculate total time spent on the basis of max updated_Date.

Show in text box and pivot table

Project id	Time	date	Output in time
90	6:00	1/11/2016	-
90	5:45	10/11/2016	5:45
92	1:00	2/11/2016	-
92	2:05	30/11/2016	2:05
92	3:10	15/11/2016	-

Total time spent should be 7:50 (hh:mm)

I tried it,

max(aggr(sum(time),project,date)) but it showing incorrect  6:00+3:10=9:10

I have many field also in charts.

Some issue is facing in Aggr() kindly help.

Thanks in Advance

Swati

[sunny_talwar]

Did you try this?

Time(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))

[sunny_talwar · Accepted solution]

Attaching a sample

Also, You might need Interval instead of Time

Interval(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))