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";

      end

       

      I am thinking something like that but I am not sure how to put this in the Tableau calculated field option.