
1. Re: Calculate Median for the same 30Day Period Each Year
Zhouyi Zhang Jul 13, 2017 7:09 AM (in response to natalie.tran)Hi, Natalie
Please find my solution attached.
Below is the screenshot of the result and the calculation field I created.
Hope this could help, please let me know if you have question.
ZZ

2. Re: Calculate Median for the same 30Day Period Each Year
natalie.tran Jul 13, 2017 7:41 AM (in response to Zhouyi Zhang)Hi Zhouyi,
Thank you for this. Unfortunately I'm unable to open the file.. do you mind uploading in .twb? It may be because I am using Tableau 10.1
Also, do you think it would make a difference if it was median # of Sales? For example, If the median # of Sales for 11/111/7/16 was 33 sales for the day as opposed to the dollar value?
Again, thank you for the quick response!

3. Re: Calculate Median for the same 30Day Period Each Year
Zhouyi Zhang Jul 13, 2017 7:49 AM (in response to natalie.tran)Hi, Natalie
If you want median of # of sales, Please see my updated solution below
The workbook I attached is version 10.2. If you can't open it, please follow the screenshot above which should include every calculations I used in the sample.
Please let me know if you still have problem with that
ZZ

4. Re: Calculate Median for the same 30Day Period Each Year
natalie.tran Jul 13, 2017 9:38 AM (in response to Zhouyi Zhang)The above is great, but I am not using extracted data. Any suggestions for a dynamic data source?
Thanks

5. Re: Calculate Median for the same 30Day Period Each Year
Zhouyi Zhang Jul 13, 2017 5:00 PM (in response to natalie.tran)Hi, Natalie
can you tell me what do you mean dynamic data source?
ZZ