Could I get some help with my first calculated field in Tableau?
1. First have a group of people that are located in specific rooms duirng specific dates.
2. Next I have an incident date and I need to show only the room the person was in when the incident happened.
Setup like this.
Fields for location are Room, StartDate, EndDate
The incident is a just a date and I need to display the room that the preson was in when the incident occurred or just display "not in room"
I am not sure how to fomulate the cacluated field for this in Tableau.
if incident between StartDate, EndDate;
else Location = "not in room";
I am thinking something like that but I am not sure how to put this in the Tableau calculated field option.
IF [StartDate] <= [Incident] AND [Incident] <= [EndDate] THEN
'not in room'