Showing one datapoint for "several selections"?

[#1]

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

Date	Goals	Subcategory	Score
2011-01-01	Math	Teamwork	2
2011-01-01	Math	Leadership	5
2011-01-01	Math	Analytics	6
2011-01-01	English	Teamwork	12
2011-01-01	English	Leadership	9
2011-01-01	English	Analytics	14
2011-06-01	Math	Teamwork	4
2011-06-01	Math	Leadership	3
2011-06-01	Math	Analytics	6
2011-06-01	English	Teamwork	10
2011-06-01	English	Leadership	7
2011-06-01	English	Teamwork	16

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?

[#2]

Did you do sum(Score) or just Score?

[#3]

No, I do not want to sum score... basically if I make a barchart and make the following selection

Date: 2011-01-01

Goals: Math

Subcategory: Teamwork, Leadership & Analytics

I would want this selection to show three different scores (2, 5 and 6 on one bar each)

[swuehl]

The resulting table looks fine too me, except that

on 2011-06-01, you have multiple records for English and Temwork with values 10 and 16.

You won't get individual lines for them.

You could add Score to your dimensions too and add an expression

=1

and hide this expression in presentation (talking about a straight table), but this will only work for unique combinations of Score, Date, Goals, Subcategory.

So maybe you could add a record no to the table and hide this in presentation tab of the properties?

Regards,

Stefan

[#5]

Yes the last row should be analytics, sloppy copying

So yeah, I find that each line has an unique identified with the combination of Date, Goals and Subcategory... but I still don't manage the data to show this way.

I would make a barchart with date, goals and subcategory as three individual dimensions?

And then add the Score as a expression?

So if I selected all dates (2), all goals (2) and all subcategories (3) I would get 12 datapoints... that's what I am after

[swuehl]

I believe the standard behaviour of a bar chart allows 3 dimensions and 1 expression only in stacked style.

So you will probably only get a stacked bar with stacked subcategories, right?

Is that your problem?

[#7]

Yeah, that explains it! I changed it to stack bars and it show perfectly, however this is not how I like it... I like it as a histogram (like an inflation rate chart over time?)...

Is that possible and how?

[swuehl · Accepted solution]

Could you maybe reduce the three dimensions to up to two by concatenating e.g. Goals and Subcategories, creating a new dimension?

[#9]

How would I do that the best way? I could combine subcategory and goal as "one selection", ie always requiring a selection of both of those...

[swuehl]

Hm, not sure what you mean..

Please have a look at attached (and at the script part for concatenation).

Maybe like this?