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)
|Product||Territory||Day Name||Dates||Week||Actuals||Projections||Day No|
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.