Hello, I'm looking to show only the past week of sales dates while showing the rank of that day's sales out of the past year. However when I limit the dimension to only show the past week it only ranks it out of five. Is there a way to only show the past week but still show the rank from the past year?
The sales dates I want to show:
How I want the ranks to look:
Current Dimension:
=if((weekname(sales_date)=weekname(now()-7)) and (weekday(sales_date)<5),sales_date)
Current Measure:
=Rank(sum({<sales_date={">=$(=vPastThreeMonthStartDate)<=$(=vMaxDatePastWeek)"}>}net_sales))
Thanks for you're help!