2 Replies Latest reply on Nov 22, 2016 3:38 AM by Bart Jan van Trommel

    adding rows in Tableau via an algorithm

    Bart Jan van Trommel

      I export all invoices which I have sent to my customers in a csv file, which I load in Tableau.

      Each row in the cvv represents one invoice, and contains fields with all kind of data, like customer name, address, invoice turover, kind of product, etc.

       

      For each customer I know the end date of the contract, so I know which invoice I will be sending on which date in the future.

       

      Is it possible in Tableau to add rows in Tableau, where each row is a future invoice (with the same data as mentioned above, but a different invoice date), and that the adding of the rows stops as soon as the future invoice date exceeds the end date of the contract with that customer?