Counting duplicate IDs with more than one date

[beadyeyesbb]

Hi,

not really sure where to start with this and looking for some guidance please 🙂 

I have a data set which has Session IDs (the customer), date of travel (Outbound departure date) and the Route code and a metric of how many times that date of travel bas been viewed by the session ID. 

What I am trying to work out is how many of those session IDs view more than one Outbound date.

So it's effecitvely counting duplicate sessions ID's. 

Hopefully makes sense. 

I have uploaded data set to assist. 

[Jonathan-Sherman · Accepted solution]

Hi @beadyeyesbb,

It sounds as though you want to use the summarise tool to group by session id and count (or count distinct) the outbound dates. Count will tell you how many outbound dates you have, count distinct will tell you how many unique outbound dates you have.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[DavidP]

You can use the Tile tool configured as shown below. Tile Sequence Numbers > 1 are duplicates