5 Replies Latest reply on Apr 10, 2018 6:40 AM by Vimal Annamalai

    How to create a comparison report between students marks?

    Vimal Annamalai

      HI All,

       

      I'm a beginner in Tableau. Could anyone please help on this. I have mentioned my sample requirement below using that, i want to create a comparison dashboard between students Marks.

       

       

      DataSource Table:-

           

      Student MathsSciencePhysicsComputer Science
      A60758060
      B70809275
      C75877570
      D80607067
      E75846475
      F92756070
      G69708480

       

       

      My Requirement Is Like:-

      Subject Student A (stud)

      Student B

      (comp stud)

      Percentage Difference
      Maths6070-15.38
      Science7580-6.45
      Physics8092-13.95
      Computer Science6075-22.22

       

       

      Color Legends -

      When Percentage > 0 =  green

      When Percentage < 0 =  Red 

       

      Positive
      Negative

       

      Filters I have two filters like :-

      1) Student

      2) Comparison Student

       

      Facing Problem:-

      This is the part where i'm facing problem & having doubt:-

      • If I change 'C' in Student Filter only 1st column should display the Student C marks not both columns
      • If I change 'D' in Comparison Student Filter only 2nd column should display the Student D marks not both columns

       

      Could anyone Please help me in this.?