14 Replies Latest reply on Feb 1, 2019 1:30 PM by Christopher Cheng

    Distribute an Amount for the 12 Months after the date

    Alexandros Aliferis

      Hi all,

       

      I am having trouble trying to figure out a solution for trying to distribute an amount over the 12 months after the included date.

       

      It would look something like this (but would prefer to have it on a line graph)

       

      Included Date: 12/1/2020, Amount: 42,000

       

      Date of Dispersed Amount
      Dispersed Amount
      1/1/20213,500
      2/1/20213,500
      3/1/20213,500

      Etc, Etc.

       

      Is this possible to do straight into Tableau? As in with a formula or calculation? Or do I have to do some manual work within an excel sheet (which would NOT be preferred, but will do if all else fails)?

       

      I've looked at different forum discussions, but could not find a solid answer. Let me know if you need more detail.