Forum Discussion
Solved
Traffic Flow - Rank and Counts
Hi all! I've got a funny question I can't quite wrap my mind around. I have a data set with a user, a date/time, and a location. I want to create an idea of traffic flow per day per user, so that I c...
SamErenberger , I think you need a rank column like
rankx(filter(Table, [User_id] =earlier([User_id])), [date time],,asc,dense)
In case you do not have a date time column
create one
date time =[date] + [time]
amitchandak
Super User
Super UserSamErenberger , I think you need a rank column like
rankx(filter(Table, [User_id] =earlier([User_id])), [date time],,asc,dense)
In case you do not have a date time column
create one
date time =[date] + [time]
Thank you! That works great. This also gives me a great starting point of researching more into the RANKX function!