Hi I looked at your book but could not look directly at the data and the connection
I did something similar for a client yesterday and create the join shown below
the "Sheet 1" is just a date ladder that encompasses the entire date range plus
the Start and End dates are from his data - he was looking at when events were active between a start and end date
the join resulted in a record (real record) for each date/project combination - they could then place Date on the viz and on a context filter and still use a slider on to limit what was shown in the viz -
I can't tell looking at your data - which date(s) to use - but it might give you a thought
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you. It worked as expected.