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!
5 réponses
I will answer in Japanese, so please translate it.
1.日付を複製して、文字列にします。
2.日付を複製して、DATEADD('day',30,日付) ※これが30日後の日付
3.1と2を計算でつなげます
4.フィルターに、1をいれて、年月日にします。※すべて利用する
5.ダッシュボードで配置します
6.分析>フィルター で、日付を選択します。
Sorry if I misunderstood.