1 Reply Latest reply on Mar 6, 2016 4:20 AM by Yuriy Fal

    Daily Percentage Calculation

    jitan.chainani

      Hi Guys,

       

      I have a data set and need to calculate the percentage of each day Mostly the % of column is calculated as a quick table calculation but in this scenario the calculation is different.

       

      The product is launched in different countries on a different day. For example Japan has a launch date of  Thursday  -  So we need to calculate the % of each day from Thursday to Sunday as follows -

       

      i.e. sum(Actual on Thursday)/sum(Actual Thursday:Sunday)  = % On Thursday

           sum(Actual on Friday)/sum(Actual Thursday:Sunday) =  % On Friday

           sum(Actual on Saturday)/sum(Actual Thursday:Sunday) =  % On Saturday

           sum(Actual on Sunday)/sum(Actual Thursday:Sunday) =  % On Sunday

         

      For Monday and Tuesday we

       

      Monday Projection %  = Sum(Actual on Monday)/sum(Actual Thursday:Sunday)

      Tuesday Projection % =  Sum(Actual on Tuesday)/sum(Actual Thursday:Sunday)

       

                                                                                  

      ProductTerritoryDay NameDatesWeekActualsProjectionsDay No
      1001JapanThursday3/19/2015Week 1      598,99215%1
      1001JapanFriday3/20/2015Week 1      926,28822%2
      1001JapanSaturday3/21/2015Week 1   1,523,56237%3
      1001JapanSunday3/22/2015Week 1   1,076,17726%4

      and this is for  week 1 just for one product

       

      Week 2 starts on Thursday again because the launch was previous Thursday and same calculations for projecting week 2.

       

      Can you please suggest on how to do this in Tableau? I have attached the data set to this discussion.

       

      Thanks,

      JC