IBM Business Analytics

 View Only

Rank by unique text

  • 1.  Rank by unique text

    Posted Fri March 01, 2024 02:25 PM

    Hi all, 

    I currently have a table like the below where the rank is based on the order of the table. 

    I want to rank it based on the location and time (table 2)

    Can anyone help with this please?

    Location Time Rank
    Manchester 00:15 1
    Liverpool  00:30 2
    Manchester 00:45 3
    Reading 01:00 4
    Reading 01:15 5
    Manchester 01:30 6
    Bristol 01:45 7
    Liverpool  02:00 8
    Bristol 02:15 9
    Bristol 02:30 10
    Liverpool  02:45 11

    Location Time Rank
    Manchester 00:15 1
    Liverpool  00:30 1
    Manchester 00:45 2
    Reading 01:00 1
    Reading 01:15 2
    Manchester 01:30 3
    Bristol 01:45 1
    Liverpool  02:00 2
    Bristol 02:15 2
    Bristol 02:30 3
    Liverpool  02:45 3


    ------------------------------
    Ricky Butler
    ------------------------------