Skip to main content

Hi,

 

I would like to create a filter date that allows the user to filter by 30 days intervals showing the start and end date or only the end date. I created a bin with the "Order Date +1" that creates the 30 days intervals but the filter show just the name of the interval, so it is very dificult for the user to know which dates are.

 

Is there any way to achieve this?

 

Please find attached the workbook.

 

Thank you so much!

 

Filter date with intervals of 30 days 

5 réponses
  1. 6 août 2025, 13:27

    I will answer in Japanese, so please translate it.

    1.日付を複製して、文字列​にします。

    2.​日付を複製して、DATEADD('day',30,日付) ※これが30日後の日付

    3.1と2を計算で​つなげます

    4.フィルターに、1をいれて、年月日にします。※すべて利用する

    I will answer in Japanese, so please translate it.

    5.ダッシュボードで配置します

    6.分析>フィルター で、日付を選択します。

    imageSorry if I misunderstood.

0/9000