4 Replies Latest reply on Feb 23, 2017 6:58 AM by Eoghan Lyons

    Apportion an Annual Target Automatically over the year

    Eoghan Lyons

      Hi there,

       

      I'm trying to setup some targets over the year to be divisible by the amount of the year that has passed by, and to be correct as you collapse or expand a date field.

       

      For example, I attach a packaged workbook. I have established targets as a one line item for each person, for the year 2017. This is not a date, so I have used the MakeDate function and assigned 1st Jan to this.

       

      Is there any way I can create a function or field within Tableau so that the targets can be evenly spaced out to the date level preferred, be it a full year, quarter, month, day etc?

       

      Many thanks,

       

      Eoghan.