Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone have an idea on how to group a set of tasks so that the group is complete workflow. I have thousands of asset records and each asset record has an audit trail of actions taken. There is a series of action that constitutes as a complete workflow i need to find a way to group them together. For example
Asset Record | Bucket Groups | Task Record | Task Name |
---|---|---|---|
11111 | Group 1 | 123 | PickUp |
11111 | Group 1 | 585 | Bag |
11111 | Group 1 | 168 | Return |
11111 | Group 2 | 1293 | PickUp |
11111 | Group 2 | 1496 | Bag |
What is the grouping in the above example?
Column 2 "Bucket Groups" is the example. Pickup, Bag, Return is the workflow being followed.
apply if clauses of range (or) use Interval match to get your buckets
Not sure how interval match would help me create buckets.