I have a question on filtering by dates for a Gantt Chart.
I've created my Gantt chart based on contract start/end date and duration being the size. The x-axis being the contract start date. What I want to do is add a filter to be able to see what contracts are in progress or starting during a certain timeframe and not see anything before that time frame.
For example if contract A starts on May 1 2022 - through May 30 2002 and contract B starts April 1 through May 2022 and I want to filter to show anything in progress or starting after April 10th, what is the best way to do this? I don't want the x-axis to show anything prior to April 10th, but I want it show that both contracts because contract B will be in progress during that time.
Any help or thoughts would be greatly appreciated!
Hello @Meredith Foulke ,
You'll need to scaffold your data with a date table to create a single record for each date within the range of start and end date. Then use the new date field on the filter shelf.
See attached.
@Robert Breen
