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.

      Thanks

      Krishna.