Hello, I'm trying to get the multi-series line 2d chart working. I'll make it as simple as I can:
A table has a 3 column: date, coke_price, pepsi_price.
The idea is to have a chart with date as x axis, prices as y axis...the lines show coke and pepsi prices going up and down, comparing the two.

The problem?? As I understand it...the x axis values are taken from the column names (date, coke_price and pepsi_price) and I don't get the reason for that...I'm quite new at SQL but I wonder why I should turn a table this way...and most of all...how can I do that??? Should a table be designed as I did?
What is wrong with it??
Thank you for your patience.
Magdy

Hi, if you want you can send me on email This e-mail address is being protected from spambots. You need JavaScript enabled to view it detail description of your problem and I will help you with create SQL query. I need dump of database table from which you want fill chart to create SQL query.

Thank you, just sent.
Magdy

Well, ARTIO solved my request with a complicated sql query that turn a normalized table in a data structure compatible with the ARTIO extension.
I wonder if the extension itself should be modified a little bit so to be able and get data from normalized db as most of the data are in this form.
Anyway, for the moment I thank ARTIO for the quick support!!