16 Replies Latest reply: Mar 14, 2013 1:40 AM by Nandha Kumar RSS

    Showing one datapoint for "several selections"?

      I had a really difficult time to Google this but consider that I have the following date:

       

      DateGoalsSubcategoryScore
      2011-01-01MathTeamwork2
      2011-01-01MathLeadership5
      2011-01-01MathAnalytics6
      2011-01-01EnglishTeamwork12
      2011-01-01EnglishLeadership9
      2011-01-01EnglishAnalytics14

      2011-06-01

      MathTeamwork4
      2011-06-01MathLeadership3
      2011-06-01MathAnalytics6
      2011-06-01EnglishTeamwork10
      2011-06-01EnglishLeadership7
      2011-06-01EnglishTeamwork16




       

      Obviously the real data has much more datapoints but the same amount of fields (four fields), I want to be able to show each individual score based one selection and I do not know how to achieve this.

       

      I thought that I would make a diagram with Date, Goals and Subcategory as dimensions and Score as an expression, however this does not seem to work?What I am doing wrong and how would I be able to achieve this?