Hi Josephine.Jesuraj ,
You can use Window_median
Link for Window_function :: Breaking BI: Working with Window Calculations and TOTAL() in Tableau
Try doing this, if this will not work ,please attach your workbook .
I tried this but I am not sure how to calculate median for that particular weekday. For Monday , I should consider only previous 5 Monday's count similarly for other weekdays.
I'm not certain this is what you want but maybe it will help I am not well versed in Median
first create the columns as weekdays and rows and the rows as weeks
I dropped sales on the viz and then I used this formula - percentile at .5 returns the Median value - the -5 looks back 5 weeks and the final 0 says end at this week
the table calc is set up as down
and it returns this
the workbook is attacheed
median test.twbx 1.2 MB
I impelemented median using the Windows_Median function and it is working as expected.
Thanks Nikher. I implemented the running median using Windows_Median function.
glad you dot a solution