Counting rows for event sequences

Hello Selva-Salimi,

Thanks for the reply!  Simple solution, which I like.

However, not exactly what I was looking for...  🙂

Yous solution in table at lower right, orginal table at upper left.

Your solution gives the total count of each event type in the work item, along with the first date/timestamp.  I'm looking for a more detailed view that shows the event type count and first date/time for each GROUP of same events in the work item.  I expect to see, taking Extents Changed as an example:

date/time 1     Extents Changed     count A

date/time 2     Extents Changed     count B

date/time 3     <some other event>     count C

date/time 4     Extents Changed     count D

etc

:

:

 Maybe another column trick?

Thanks,

Hans