6 Replies Latest reply on Jan 5, 2017 1:33 AM by Siang Li Chua

    Selecting a group in Year 1 and tracking them through the Years

    Siang Li Chua

      Hi.  Suppose below is my data file.  I can easily plot the number of customer who are happy each year (see below).  Now, I wish to plot: Among those who are Happy in Year 2012, how many of them are Happy in each subsequent year (That's the bar chart below should be 3, 1, 1, 1 because Customer 4 is excluded).  How should I do it?  Thanks.

       

         

      YearCustomer IDHappy?
      20121Yes
      20131Yes
      20141No
      20151Yes
      20122Yes
      20132No
      20142No
      20152No
      20123Yes
      20133No
      20143Yes
      20153No
      20124No
      20134No
      20144Yes
      20154Yes