2 Replies Latest reply on Sep 26, 2018 7:22 AM by Xi Liu

    How to filter by date by most recent 5 periods

    Xi Liu

      I have a pie chart, the date is not in Column or Row. I want to filter by date by most recent 5 periods, it could be day, week, month etc , based on parameter selection and the periods may not be continuous. I tried RANK function but doesn't work, I also tried something like

      [Date] > {FIXED: MAX[Date])} - 5  but seems not correct. I have some other charts in the same dashboard so we can't just use a relative date filter but have to do a customized filter.

      Does anyone have an idea? thanks.