0 Replies Latest reply on Apr 11, 2018 4:02 AM by Evgeniy Soytonen

    Show cash flow depending on down payment date and credit date

    Evgeniy Soytonen

      Hi, I have some sales data extracted from BW.

      There are customer id, document id, payment terms (like 0/100 - 100% credit, 20/80 - 20% down payment/80% credit and so on), down payment date, credit payment date, net value.

      Basing on payment terms I could evaluate down payment and credit parts.

      And now i want to show on timeline at what time money should be payed.

      For example, sales data:

      Customer
      DocID
      PaymentTermsDown payment date
      Credit payment date
      Net order Value
      CustomerA100110/9030.12.201730.09.201810000$
      CustomerB10020/100null30.09.20184000$
      CustomerC1003100/015.01.2018null5000$
      CustomerD100450/5030.03.201830.09.20188000$

       

      So on chart for X axis i want to have timeline 2017-2018 and on Y Down payment value (by date), Credit payment value (by date), SumValue (by date).

      As i previously mentioned I've calculdated Down payment as NetOrderValue * Payment terms %, for Customer B it would be 8000*50%=4000, and same for Credit payment value.

       

      So i want to organize data looks like:

       

      Calendar date (X)Down payment value (Y1)

      Credit payment value (Y2)

      30.12.201710000
      15.01.201850000
      30.03.201840000
      30.09.2018017000 (9000 + 4000 + 0 + 4000)

       

      Could someone help me to understand how to mix two date fields into one inside Tableau?

      In power BI i could use external Calendar dimension for that. But here I couldn't find similar functionality.