4 Replies Latest reply on Oct 20, 2016 9:06 AM by Saby Panda

    Enhanced Level of Detail : How to fetch Data corresponding to 1st date and Latest date

    Saby Panda

      I have data corresponding to multiple dates for the same person (as shown in Table_1). I need to create a summarized tale for all the people, with the structure mentioned in Table_2.


      I have attached both the tables as excel sheets as well. In my desired output, I need an extra column, "Today's Date" (shown in yellow).


      Table_1 (What my sample data looks like).



      Table_2 (What I finally want to achieve)


      I am aware that the following columns can be derived by the following formulas :


      Date_of_First_Play : {FIXED[Person] : MIN([Date_of_Play])}


      Date_of_Last_Play : {FIXED[Person] : MAX([Date_of_Play])}


      Number_of_Play_Attempts : {FIXED[Person]:COUNTD([Date_of_Play])}


      But not sure about the columns that follow.