5 Replies Latest reply on Nov 2, 2017 10:11 PM by Sukhdeep Kaur

    Date calculation

    sudhir ranajn

      Hi Experts,

       

      I need your help. I have to calculate no of patients those are fall in between two dates.

      Lets say the two date fields are rx_date and Tx_date. So my calculation should be  when (rx_date)>(current period) and (tx_date)<(current period) then count(patient).

      Here "current period" is user selected date, which is a parameter. If I select any date from the parameter it should be the "current period" and gives me the result based on the above condition. The "rx_date" and "Tx_date" are in date format and "current period" is in string format. I cant understand how to implement this condition in tableau.

       

      Please help me with this.

       

      Thanks in advance!

      Sudhir