Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table:
QueueNo. | ActionNo. | ActionName | Start | Finished |
1111 | 5000 | Start | 08:00 | 08:05 |
1111 | 5001 | Moving | 08:05 | 08:10 |
1111 | 5002 | Parking | 08:10 | 08:12 |
1111 | 5003 | Moving | 08:12 | 08:29 |
1111 | 5004 | Success | 08:29 | 08:30 |
2222 | 5100 | Start | 09:00 | 09:00 |
2222 | 5101 | Moving | 09:01 | 09:10 |
2222 | 5102 | Failed | 09:10 | 09:10 |
I want a calculated dimension where I only see the first and last actionNo of a Queuno. I tried different methods to cut out the subactions. but I either get complete null or nothing happens.
Hope someone has an idea.
Best.
@Applicable88 multiple