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)
Product | Territory | Day Name | Dates | Week | Actuals | Projections | Day No |
1001 | Japan | Thursday | 3/19/2015 | Week 1 | 598,992 | 15% | 1 |
1001 | Japan | Friday | 3/20/2015 | Week 1 | 926,288 | 22% | 2 |
1001 | Japan | Saturday | 3/21/2015 | Week 1 | 1,523,562 | 37% | 3 |
1001 | Japan | Sunday | 3/22/2015 | Week 1 | 1,076,177 | 26% | 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
Hi jitan,
Something like this?
Please find the attached wb.
Hope it could help.
Yours,
Yuri