5 Replies Latest reply on Oct 8, 2018 8:44 AM by Shinichiro Murakami

    Set date filter to second to last date?

    Chad Clauson

      I have a week end date (DATE(DATETRUNC('week', [Etl Load Dttm], 'Sunday'))+6) dropdown dashboard filter on all my dashboards currently defaulting to latest week. The issue is that when a new week starts, I only have one day's worth of data which isn't very meaningful. Instead of defaulting to the latest value in that dropdown, how can I set it to default to the previous week? (e.g. instead of defaulting to week end date 10/13/2018, default to week end date of 10/6/2018 which is the previous value in that list)