1 Reply Latest reply on Dec 10, 2018 2:50 PM by Patrick A Van Der Hyde

# Need Calculation for Weekday and Week Number Average Sales between Start Date and End Date Parameters

Hi

I'm looking for solution for the below 3 points which I have attached the Power point Presentation with the mentions.

Slide1 - I have created Parameters for Start Date and End Date - Here end date I have selected 14th but in data table we have data till 13th only-please suggest how can we show  14th data with out selecting end date 15th and even with out mention the time like (11:59:59 PM)

Slide2 - Here I have created parameters of Start date and end date, I need to show a average sales amount by weekday like (Sundays average till Saturday’s average.) Suppose we have 3 sundays are there in selected period ( sum of sales amount in sundays/ no of sundays) like this I want to calculate in tablaeau. Please help me with the calculations like below

Slide3 - Here I have created parameters of Start date and end date, I need to show a average sales amount by week number like (week39 average, week40 average and week 41 average.) Here in week 41 we have only 5 values. Here it needs to be calculated according to the days (sum of sales amount for the week 41/no of days in a week 41). Please suggest the calculation for this . Like below

Regards,

Subhashini

• ###### 1. Re: Need Calculation for Weekday and Week Number Average Sales between Start Date and End Date Parameters

Hello Subhashini,

Please review Current vs Previous Period to Date Comparison  as a starting place for several examples of date calculations with Tableau and then this post - FAQ:  To Date Calculations  has several other examples to work from.  If you find a workbook that is similiar to your issues or you have data to share, please utilize a Packaged workbook here to share with the community.

Thank you

Patrick