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

# Daily Percentage Calculation

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

• ###### 1. Re: Daily Percentage Calculation

Hi jitan,

Something like this?