4 Replies Latest reply on Oct 9, 2018 8:59 PM by Debayan Bhattacharjya

    Tableau Issue for failed status without been reintroduced

    Debayan Bhattacharjya

      Hi, I am stuck with 1 requirement. In the below based on ProjectID,RegionID Rounds are getting created and for each Round we have a status(If marks>60) then Passed else Failed.

       

      I wanted to display the data set where the status for any Subject has been failed and then not been included in the next Round.

       

      Here for Maths in RegionID 111,it has been failed but then it passed , so wont be included.But History is in Failed state and yet not been included in Rounds 2

       

       

      Input Data Set:

       

       

      RegionIDProjectIDCategoryRoundsSubjectStatus
      101111E11MathsFailed
      101111E11HistoryFailed
      101111E11GeographyPassed
      101111E22MathsPassed
      102222e71EnglishPassed
      102222e71MathsFailed
      102222e82GeographyFailed
      102222e93PhysicsPassed
      Expected Output
      RegionIDProjectIDCategoryRoundsSubjectStatus
      101111E11HistoryFailedSince History for Round 1 is in Failed Status and not been included in Round2 for RegionID 101
      102222e71MathsFailedSince Maths for Round 1 is in Failed Status and not been included in Round2 for RegionID 102
      102222e82GeographyFailedSince Geography for Round 2 is in Failed Status and not been included in Round 3 for RegionID 102

       

       

      Regards,

      Debayan B