6 Replies Latest reply on Dec 16, 2013 11:39 AM by Nelson Deleon

    count instances based on a previous period

    Nelson Deleon

      Hi, I would like to do the following: Consider the table below

       

      persondayjob
      johnMondayoutside
      jayMondayoutside
      carlMondayinside
      johnTuesdayoutside
      danTuesdayoutside
      jayTuesdayinside

       

      On Monday two people (john and jay) worked outside. Of the two people that worked outside on Monday only one of them (john) worked outside on Tuesday. Thus, for the job outside I would like Tableau to return "2" for Monday and "1" for Tuesday. I can't figure out how to do this calculation. Any help would be appreciated. Thanks.