1 Reply Latest reply on Dec 7, 2017 1:33 PM by Hari Ankem

    Data densification: duplicate value between two dates. With sample book!

    gabriela..zorrilla

      Hi there. I wanna generate something like this:

       

      from this:

         

      INVOICE_IDAMOUNTINVOICE_DATEPAYMENT_DATE
      150001/05/201705/05/2017
      260004/05/201714/05/2017
      370008/05/201714/05/2017

       

      Basically i wanna know for each day the amount of each invoice which has not been yet paid.

       

      Right now i'm generating a view in Oracle with new records for the dates in between, but we are talking about millions of records. Wonder if there is some elegant way of doing the same in Tableau.

       

      Thanks!