I have a table of 100 dates with sales count for each date. I'd like to calculate the median sales for that entire dataset (or whatever filter I have applied at the moment) and then see how each row compares to that median calculation.
Essentially, I'd like my formula to be:
(Sales on a specific day / Median of all sales)*100 to create an index but Tableau doesn't let you mix aggregate and non-aggregate functions.
possibly, kind of depends on your data structure