2. ASPRunnerPro General questions
  3. Data Ranges on Graphs
This topic is locked

Data Ranges on Graphs

 		5/10/2009 7:53:07 PM
ASPRunnerPro General questions
C
 Conrunner author

Hi. Using ASP Runner

This is probably a really stupid question so forgive me.

I have a table with 15 Questions which people respond to and input data to a db Table. They choose "Text Answers" but through a Lookup Table Numerical answers are entered to the database.

What I want to do is display a Bar Graph for each person's score, with 15 bars, one for each of the 15 questions. However when trying to create a graph ASP Runner asks me to specify "Chart Parameters". I can only select 4 of these but it seems to me that I need to select 15 - One for each of the questions so that the graph will display all 15 questions. All 15 questions are part of the same Data Range. Clearly there is no point in having only 4 variables per data range?

I'm sure that I am making a very silly mistake here but cannot figure it out.

Please can anyone help?

Con.
Sergey Kornilov admin 5/11/2009

Unfortunately ASPRunnerPro doesn't support more than 4 data series.
According to what I see you only have one data series. What is your database structure? Probably I'll be able to suggest how you can shape data using SQL.
C
 		Conrunner author 5/12/2009

Unfortunately ASPRunnerPro doesn't support more than 4 data series.

According to what I see you only have one data series. What is your database structure? Probably I'll be able to suggest how you can shape data using SQL.


Thanks Sergey

I really would appreciate your help.

My Table has 15 fields (numeric 18,0) Q1, Q2, Q3............Q15.

Each column contains numerical values for each question.

I simply want a bar graph to show 15 bars each showing the total or average for each question.

So for example if the table was..

[Q1], [Q2], etc;

1, 2, etc;

1, 3, etc;

Then the bar graph would show

Q1 = 2 (Total of Q1 - 1+1)

Q2 = 5 (Total of Q2 - 3+2)

Etc;
Many Many Thanks

Con
Sergey Kornilov admin 5/14/2009

Con,
unfortunately it won't work with this table structure.
Here is what I meant:

UserID QuestionID Answer

-------------------------------

1 1 34

1 2 22

1 3 20

1 4 50

2 1 12

2 2 32

2 3 43

2 4 26


In this case you can run a GROUP BY query, calculating COUNT() or AVG() and displaying it as a chart.