3 Replies Latest reply on Jan 17, 2018 8:13 AM by Shinichiro Murakami

    Create a column with a counter for dates

    Bhupendra Rajawat

      I have a table where I have user ids and their event datetime. I want to create a sql query in tableau to create a column which has counter for the dates. For eg, User A first joined the app on 15 January, that is his first day. If he comes back on 17 January, its his 2nd day. I want table something like this:

       

      User               DateTime               DayCounter

      A                  15-01-2018               1

      A                  15-01-2018               1

      A                  16-01-2018               2

       

      Anyone have any idea???