3 Replies Latest reply on Mar 2, 2017 12:34 PM by Norbert Maijoor

    How to Calculate % of Target Goal

    Karen Egypt

      Hello,

       

      I was wondering if Tableau can calculate a percentage based on target value within a table.  I am trying to recreate the "% Target Goal" row in the Excel table below.  The formula in the "% Target Goal" is set to calculate the percentage of actual headcount towards the official target goal for that term (Official 100%).  For example, the % Target Goal for April 25 is 6% (799/12,931) and  the % Target Goal for May 30 is 18% (2,300/12,931).  I know that I can probably create and join another table that includes only the target goal value.  However, I would like to avoid creating another data table if possible.

       

      Thanks for your help!

       

      Karen

       

      Lead
        Measures
      2nd Wk of
        registration (10%)
      End of May (20%) 1st of June (25%) End of June (33%) End of July  (50%) 2nd  wk of August (70%)2 Wks Before
        Classes (77%)
      Opening Day (98%) Official (100%)
      Registration
        Dates
      25-Apr2-May9-May16-May23-May30-May6-Jun13-Jun20-Jun27-Jun4-Jul11-Jul18-Jul25-Jul1-Aug8-Aug15-Aug29-Aug5-Sep12-Sep19-Sep26-Sep30-Sep
      Fall 17
        Targets
      1,293 2,586 3,233 4,267 6,466 9,0529,95712,672 12,931
      Fall 17 Actuals7998001,0001,4002,0002,3002,7773,0003,1004,2674,9005,0006,2276,3007,9998,0008,50011,00012,00012,50012,75012,77012,775

      % Target
        Goal

      6%6%8%11%15%18%21%23%24%33%38%39%48%49%62%62%66%85%93%97%99%99%99%