Forum Discussion
Counting rows for event sequences
you just need to use a table in visualisation pane
add each of these column in columns part:
and then select first/last or max/min for timestamp, work item_id and first event function. add first event function twice to the columns part (drag and drop). select count for the second one.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
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
Oops - in my example above, pretend the first Events Changed in some other event.
Sorry!
