[FONT="]Hi guys,[/FONT]
[FONT="]I am looking for a query that allows me to count how many events occurred between each "x" event. The desired output is illustrated in the picture hereby attached. For instance, the second event is "x" and I would like to have as output 2. In the case of the third one is still "x", but given that the previous one is also "x" the output is 1.[/FONT]
[FONT="]Thank you in advance for any help!
[/FONT]
[FONT="]I am looking for a query that allows me to count how many events occurred between each "x" event. The desired output is illustrated in the picture hereby attached. For instance, the second event is "x" and I would like to have as output 2. In the case of the third one is still "x", but given that the previous one is also "x" the output is 1.[/FONT]
[FONT="]Thank you in advance for any help!