4 Replies Latest reply on Aug 30, 2013 2:12 PM by Matt Lutton

    Index timeline with a date sort (rank)

    Bonny McClain

      I am trying to rank according to date to generate a timeline of drug history (BrandId). I have been able to generate an index (rank) by duration but I need a sequential ranking based on medication start date.

       

      When I rank with medication start date the ranks all revert to "1"...thank you to Matt Lutton for lending a hand.