Refer below video I have created for the solution. For sake of simplicity, I have created data set only for the first 15 days of Jan. In case you want the sum of sales amount for the selected days, change the logic in calculated field formula.
If this helps, please the answer as correct so that the thread can be closed.
I can't open the file.. I have 10.5.
I will try to convert and open it.
You can check the video I have shared all the sets in there.
Ok.. I have managed to create subset of data and workbook. I have attached the workbook here.
Unfortunately, I can't create the video to post it from work environment, but the idea is as below.
First dropdown has normal "Sunday thru Saturday, plus public holidays. In case of Holidays, we have to give users ability to see upto 4 days view on each year's sales. i.e. in the screenshot below, if I were to pick +2 in second drop down, all my dates shown below would go up by 2... so 1/15/18 becomes 1/17/18, 1/21/13 becomes 1/23/13.. This way, users can see how much was lift we had days after holidays...
The first dropdown works perfect in normal operation. I need to add the condition where first I have to add days to currently filtered view and then pull those records and sort it.
Hope the attachment makes it easier to understand.
BTW, many thanks Rahul for your post. I watched the video. You have great feature, but you are showing sequential dates, in my case it can be random.
Sample4TabComm.twbx 43.7 KB
wanted to update you guys.
So I solved it with little bit twist on dataside as well. I modified data to pair with my logic from Tableau side so that it can work.
I have updated the code field to include word "REGXXX#" where XXX is holiday type and # is 0 to 4 and I inserted regular rows plus 4 more rows for that data.
Then I updated calculated field to use logic accordingly.
There was an issue still with "Thanksgiving" and "BlackFriday" , so removed all BlackFriday entries and using only ThanksGiving.
Let me know if anyone needs calculated field. I don't know if this is universal problem people face or not, but at least it was a good challenge for me.
Thank you for your support.