1 Reply Latest reply on May 31, 2016 11:37 AM by Joe Oppelt

    Every other year repeat attendance?


      Struggling to get this setip correctly in tableau .. any help very appreciated.


      By unique Registrant ID, I'm hoping to look at the % repeat users on a every other year trend ?


      - workbook attached with sample data

        • 1. Re: Every other year repeat attendance?
          Joe Oppelt

          (Note to self:  Workbook is 9.2)


          Not really sure what you mean by "repeat every other year".


          What I did here was made a copy of the data source, and in the copy I made a calc to modify the year by adding 2.  Then I joined the copy by Registrant and by the hacked year value.  This will hook the copy to the original by Registrant, and for each row in the data source, look at the same row two years ago (if any).  It's a trick for offsetting dates to look at some prior-year analysis.

          I don't know if that's really what you are looking to do, but if it is, that's how you can compare this year to two years ago.