Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
2 years ago
Solved

Rank Customer Appointments by type

Hi Experts I have been trying this out for several days, I need to rank a table of appointment by type.  Each customer has several appointments of different type and I need to rank within each type ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Elisa112 , Create a new column

    Rank = Rankx( filter(Table, [UserID] = earlier([UserID]) && [Meeting Type] = earlier([Meeting Type])), [Meeting Date],,asc,dense)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Elisa112 , Create a new column

Rank = Rankx( filter(Table, [UserID] = earlier([UserID]) && [Meeting Type] = earlier([Meeting Type])), [Meeting Date],,asc,dense)