Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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)
close enough, this is the correct expression.
TIME(aggr(min({<[date-added]={'$(=DATE(MAX([date-added])))'}>} TaskStartTime), TaskOperator, [date-added]),'hh:mm')
Thanks