3 Replies Latest reply on Oct 5, 2018 1:58 PM by Chad Clauson

    Default to latest date/week dashboard filters

    Chad Clauson

      I have two dashboards, one has a dashboard filter based on week end date (calculated field: DATE(DATETRUNC('week', [Date], 'Sunday'))+6) and the other dashboard a single-date filter (created by relative date filter last 7 days, then MDY sub filter with relevant values; show the MDY filter on dashboard).

       

      I have a daily refresh set, so new options appear on the filter once a week on the first filter, and every day on the other dashboard. However the default filter date does not change to the latest week/date in the list/slider. How can I get it to default to the latest value in those two filters?