4 Replies Latest reply on Nov 29, 2018 10:33 AM by Ramakrishna Rallapalli

    Days calculation

    Ramakrishna Rallapalli

      Hi Team,


      I have invoices, Start date, finished date, and invoice status columns.  If invoice status is Finished, the number of days = InvFinishdate - InvStartDate.  If Invoice status is open, the number of days = Today()-InvStartdate.

      I would like to show as per the example shown below, 50 days 1 invoice, 34 days 1 invoice, 29 days 1 invoice (all finished) and 1 day 5 invoices (open) in Tableau. 


      Excel piviot.


      Tableau :



      Appreciate your help.