Hi, I would like to check that sequence of activities per every unique ID is correct or not. It should be based on the timestamp. Out of all activities (can be repetitive), I need to check that the main 7 have happened and the order of them was correct. Example below: ID TimestampActivityCorrect1232020-10-01 01:01:13ACYes1232020-10-01 01:01:14ACYes1232020-10-01 01:01:15DCYes1232020-10-01 01:01:17ACNo2132020-10-01 02:01:13ACYes2132020-10-01 03:01:13DCYes2132020-10-01 04:01:13GSNo

Sequence of activities

Hi,

I would like to check that sequence of activities per every unique ID is correct or not. It should be based on the timestamp.

Out of all activities (can be repetitive), I need to check that the main 7 have happened and the order of them was correct.

Example below:

ID	Timestamp	Activity	Correct
123	2020-10-01 01:01:13	AC	Yes
123	2020-10-01 01:01:14	AC	Yes
123	2020-10-01 01:01:15	DC	Yes
123	2020-10-01 01:01:17	AC	No
213	2020-10-01 02:01:13	AC	Yes
213	2020-10-01 03:01:13	DC	Yes
213	2020-10-01 04:01:13	GS	No

Datasets

Tips and Tricks

Best Practices

Accepted answers

philipmannering

Hi @svergtanya

Maybe you can adapt something from this,

Correct Order.yxmd

All comments

Kenda

Hi @svergtanya

I have just a few clarifying questions to make sure I answer what you're looking for

1. Is the Correct field the one you are trying to automatically generate here?

2. Can you explain why records 4 and 7 are No?

svergtanya

Hi @Kenda

1) Yes, I would like to generate the field "Correct"

2) I have a process, where are rules, which activities should be followed by which. For example, 'AC should be followed by DC and don't be repeated later after next activity.

If to look at them aggregated, so input can look like this 'AC, AC, DC, GC, FC, HF, TS, OP, DC, AC, ML'

and pattern should be 'AC, DC, FC, OP, TS, ML'

So, then if to color input, green - correct and red - wrong.

'AC, AC, DC, GC, FC, HF, TS, OP, DC, AC, ML'

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703