Sorry if this is a newbie question. I have a customer that wants to block off a range of days based on a single date. In the example there is instruments sent for a surgery (date), they want to show that inventory as blocked for 2 days before and 2 days after given the surgery date. They would like to show this in a calendar view with the bars stretching from the point of 2 days before to days after. In the example provided the bar currently sits on the surgery date. Help please?
I'd recommend going with a gantt chart approach Creating a Gantt Chart for Small Time Increments | Tableau Software
I'd create a new calculated field as dateadd('day',-2,[Surgery Date]) for the start date and then do a +2 for the end date. You could then use these fields in the approach I've linked to above.