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

# 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-01MathAnalytics6
2011-01-01EnglishTeamwork12
2011-01-01EnglishAnalytics14

2011-06-01

MathTeamwork4
2011-06-01MathAnalytics6
2011-06-01EnglishTeamwork10
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?

• ###### Showing one datapoint for "several selections"?

Did you do sum(Score) or just Score?

• ###### Showing one datapoint for "several selections"?

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

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

• ###### Showing one datapoint for "several selections"?

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.

=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

• ###### Showing one datapoint for "several selections"?

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

• ###### Showing one datapoint for "several selections"?

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?

• ###### Showing one datapoint for "several selections"?

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?

• ###### Showing one datapoint for "several selections"?

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

• ###### Showing one datapoint for "several selections"?

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...

• ###### Re: Showing one datapoint for "several selections"?

Hm, not sure what you mean..

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

Maybe like this?

• ###### Showing one datapoint for "several selections"?

I have personal edition so I cannot really see it but I can see the code:

Goals,

Subcategory,

Score,

Goals &'-'& Subcategory as GoalSubs

However, I can not see the structure of your graph, maybe you can take a printscreen of dimensions and expressions? Sorry if I am asking to much

• ###### Showing one datapoint for "several selections"?

Sure:

this is my script:

Goals,

Subcategory,

Score,

Goals &'-'& Subcategory as GoalsSubs

FROM

(html, codepage is 1252, embedded labels, table is @1, filters(

Remove(Row, Pos(Top, 14))

));

Then I did just bar chart with

dimensions Date and Goalssubs and Expression Score

It looks like this:

• ###### Showing one datapoint for "several selections"?

Thank you very much! I managed to solve it and you been very patient and helpful, big star for you my friend!

• ###### Re: Showing one datapoint for "several selections"?

Good show stephen.

Can i do this without concatenation?

I want the same scenario like the attached screen.

" Sample_1 is the sample given by client "

" QV_Result is the report that i am getting in QV. "

I very well know i am doing a small mistake but i am not able to fix that.

Can you help me here?

Rgds,

Nandha

• ###### Showing one datapoint for "several selections"?

Another way to get the same output as shown by sweuhl is to create a calculated dimension of Goals and Subcategories in the chart dimensions.

• ###### Re: Showing one datapoint for "several selections"?

Do you know how to show the some in 1/1/2011 (48) as total and other date in this chart?

• ###### Re: Showing one datapoint for "several selections"?

Good show stephen.

Can i do this without concatenation?

I want the same scenario like the attached screen.

" Sample_1 is the sample given by client "

" QV_Result is the report that i am getting in QV. "

I very well know i am doing a small mistake but i am not able to fix that.

Can you help me here?

Rgds,

Nandha

Attachments: