4 Replies Latest reply on Oct 3, 2017 3:25 AM by Ritesh Bisht

    How to flag a date when you have only starting and ending dates

    christian juillard

      Hi experts

      I am a new joiner in Tableau world.

      What I need is to count the number of users according a selected month.

      My data are like  USER / DATE IN / DATE OUT, let's say

      U1 / 15.06.2014 / 27.08.2015

      U2 / 02.12.2014 / 28.09.2017

      U3 / 12.04.2015 / null

      U4 / 10.12.2015 / 04.04.2016

      I have created a calendar from january 2014 until december 2020

       

      WHAT I WANT IS :

      When I select a month, I want to get the nulber of users having this month between dates IN and OUT

      Examples:

      Month Selected     June 2015     may 2014     dec 2016

      Should return          3                     0                    2

      thank you for your help