Forum Discussion

nckpedersen's avatar
nckpedersen
Icon for Helper I rankHelper I
4 years ago

nth Instance in Power Query to count pageviews by session

I am trying to extrapolite user site flow using a pageview report that has unique session id, visit date/time, url, and referrer url. 

 

I'd like to sort by chronological (ascending) on the date column, then duplicate the table, remove all columns but session id, remove duplicates, assign an index value. Then merge that table with original, sort by index value, then count instance of that index value. 

 

I need a formula like =countif(A$1:A1)

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
    Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.

  • OliT's avatar
    OliT
    Icon for Resolver I rankResolver I
    4 years ago

    Hi nckpedersen 

    >> I'd like to sort by chronological (ascending) on the date column, then duplicate the table, remove all columns but session id, remove duplicates, assign an index value. Then merge that table with original, sort by index value, then count instance of that index value. 

    So where are you stuck now? What do you need us to help you with?  If possible, please share a sample process diagram and your sample data.

     

     

    Regards,

    OliT