Hi team, I want to create a sheet which consist of some visuals as below:
I want to put use a control : week_of_the_year in all sheets, but only for this particular sheet, i need to show 4 previous week of the chosen week (viz 1). So let’s say a user choose week 35, i want viz 1 shows week 31-34, viz 2&3 show week 35, and all other sheet shows week 35. How to achieve that? Thankyou!
Jessica
Hello @jesstnto, while our data might be different, I was able to build out calculated fields to handle the filtering you are looking for. The top 2 tables are filtered to show data from the previous 4 weeks and the third table is filtered for the current week. I am using ifelse fields to only return the orders if they exist within the previous 4 weeks along with standard date filtering to only include values from the current year.
You can see the fields and filters here:
Dynamic Filtering
Let me know if you have any questions!
Hi Dylan, that’s helping a lot! Thank you so much! 
