1 Reply Latest reply on Jun 6, 2012 10:50 PM by Dimitri.B

    Location during incident

      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.