Help with an expression

[rustyfishbones]

Hi All,

I have the following expression.

ONLY({<[date-added] = {'$(=DATE(MAX([date-added])))'}>}TaskStartTime)

the expression returns the following data, I only want the first time for each operator for that day, see in bold.

TaskDescription	TaskOperator	TaskEndTime	Date	ONLY({<[date-added] = {'25/06/2018'}>}TaskStartTime)
Picking	Hyfb Qiheepzq	10:04:00	25/06/2018	08:33:00
BREAK/LUNCH	Hyfb Qiheepzq	10:15:00	25/06/2018	10:04:00
Picking	Hyfb Qiheepzq	13:04:00	25/06/2018	10:15:00
BREAK/LUNCH	Hyfb Qiheepzq	13:38:00	25/06/2018	13:04:00
Picking	Hyfb Qiheepzq	15:12:00	25/06/2018	13:38:00
BREAK/LUNCH	Hyfb Qiheepzq	15:23:00	25/06/2018	15:12:00
Picking	Hyfb Qiheepzq	15:23:00	25/06/2018	15:23:00
Picking	Jfkee Inpqdc	10:05:00	25/06/2018	07:31:00
BREAK/LUNCH	Jfkee Inpqdc	10:20:00	25/06/2018	10:05:00
Picking	Jfkee Inpqdc	12:39:00	25/06/2018	10:20:00
BREAK/LUNCH	Jfkee Inpqdc	13:18:00	25/06/2018	12:39:00
Picking	Jfkee Inpqdc	13:18:00	25/06/2018	13:18:00

[sunny_talwar]

Can you add this expression to the bottom table and share a screenshot? My guess is that it is related to rounding issues....

Min(TOTAL <TaskOperator,[date-added],TaskDescription> {<[date-added] = {'$(=DATE(MAX([date-added])))'}>}TaskStartTime)

If this is rounding issue.. may be you can try this

If(Round(TaskStartTime*86400) = Round(Min(TOTAL <TaskOperator,[date-added],TaskDescription> {<[date-added] = {'$(=DATE(MAX([date-added])))'}>}TaskStartTime) * 86400), TaskStartTime)

[rustyfishbones]

close enough, this is the correct expression.

TIME(aggr(min({<[date-added]={'$(=DATE(MAX([date-added])))'}>} TaskStartTime), TaskOperator, [date-added]),'hh:mm')

Thanks