Counting duplicate IDs with more than one date

Question

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.

Analytics _PAX Session ID 20200527-20200527.csv

Jonathan-Sherman · Accepted Answer

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