I have a dashboard with 3 tables in it: current week, previous week, and historical week. The historical week is controlled by a 'week #' slicer.
I am trying to display the week number and date range in each card title. for example the table titles should show "Current week # 19, 5/4/25 - 5/10/25", "Previous week # 18, 4/27/25 - 5/3/25", and the historical table would show similar depending on what week is selected in the slicer.
The only part of this I can get working is the week number on the historical table, since that table is actually filtered on 'week #' otherwise they just say "All Time" or "This Week"/"Previous Week"
Any guidance would be great, also I'm pretty much brand new at DOMO