I have a date table and I want to create a hierarchical filter like in the picture.
As you can see, dates start in 1900 and go through 2999.
I only want to show dates from 2018 to today.
I create a new column:
isInRange = IF(d_date[date]>=DATE(2018,01,01) && d_date[date]<=TODAY(),TRUE(),FALSE())
So I put a filter "isInRange = true"
If in the filter the date is shown "regularly", it works, but if it is hierarchical, I still will see dates from 1900 to 2999
Hi @fabiomanniti ,
As you described, the filter condition does not work for date columns with a hierarchical structure. Whereas a normal date column can successfully apply the filter condition.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@fabiomanniti , Create custom columns like a month, year, qtr, etc, and use that. Try to avoid auto-time intelligence.
Use Date Table.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!