1 Reply Latest reply on Nov 16, 2018 8:51 AM by ShivaRam Chennapragada

    Target Achievement - 10.4

    Mikey Michaels

      Thank you all so much for all your help this week.

      I'm oh so close to finishing my first interactive Tableau dashboard!!!

       

      Quick question - on the attached I'm trying to figure out the target % achievement for February and March. My target is "hard coded target" and my actual is Pivot Field Values.

      I tried to create a simple calculated field called Monthly Target Achievement (pivot table values / hard coded target) however, this just returns blanks in my tooltip.

       

      I also want to create a YTD Target Achievement Rate for each month that shows how much of my year-end target has been achieved. My year-end target is my Sept 2018 target.

       

      Thank you all so very much!!!

      Cheeerss!