SQL Query for multi series line chart

[westy]

Hi there, let me first say what a great product!

 

 

 

I want to create a multi series line graph from a table in a mysql database.

 

 

 

I want to plot a line for each unit, of the results over time.

 

 

 

So the category should be time, and the each unit_id should be a series.

 

 

 

I have the following table in mysql:

 

 

 

unit_id | time | result

 

A | 1 | 10

 

A | 2 | 12

 

A | 3 | 15

 

A | 4 | 16

 

B | 1 | 5

 

B | 2 | 7

 

B | 3 | 9

 

B | 4 | 10

 

C | 1 | 16

 

C | 2 | 18

 

C | 3 | 20

 

C | 4 | 22

 

 

 

 

 

How should my SQL query(s) look to get the data appropriate for a multi series fusionchart line chart?

 

 

 

Should I do one query for category as

 

 

 

SELECT DISTINCT 'time'

 

 

 

then a query for each series as

 

 

 

SELECT 'result' WHERE 'unit_id' = 'A'

 

SELECT 'result' WHERE 'unit_id' = 'B' etc

 

 

 

and as long as the series queries have the same number of records as the category query and are in the same sort order its ok?

 

 

 

 

 

 

 

Thanks!

Edited March 8, 2010 by Guest

[Sanjukta]

Hi,

 

Welcome to FusionCharts Forum!

 

Please refer to the following link to get an idea about how that data is plotted from the database in ASP.

http://www.fusioncharts.com/docs/?ASP_DB.html

 

Could you please let us know the Server-side scripting language you are using so that we can help you more on this?

 

Looking forward to your feedback.