Chart multiple series with same dataset
Hi,
Is there way to create a chart containing multiple series linked to the same dataset and each serie will be divided by grouping on a column?
If no, what is the normal way of adding multiple series linked to a database? Should I create 1 dataset for each serie?
Thank you.
E.g. let say we have the records below in 1 dataset.
Car;10/10/2011;1
Car;11/10/2011;2
Car;12/10/2011;1
Car;13/10/2011;5
Bus;10/10/2011;0
Bus;12/10/2011;0
Bus;13/10/2011;1
Bus;14/10/2011;1
I would like to get all "Car" records in 1 serie and all "Bus" records in another serie. I hope you see my point.
Is there way to create a chart containing multiple series linked to the same dataset and each serie will be divided by grouping on a column?
If no, what is the normal way of adding multiple series linked to a database? Should I create 1 dataset for each serie?
Thank you.
E.g. let say we have the records below in 1 dataset.
Car;10/10/2011;1
Car;11/10/2011;2
Car;12/10/2011;1
Car;13/10/2011;5
Bus;10/10/2011;0
Bus;12/10/2011;0
Bus;13/10/2011;1
Bus;14/10/2011;1
I would like to get all "Car" records in 1 serie and all "Bus" records in another serie. I hope you see my point.
Comments
As I'm using dataset, I have to build manually the XSource and YSource and add each of them into the Chart object via script. Is there a fast way to get 'Jan;Feb;Mar;Apr' result from a dataset or should I manually iterate on a masterdata band a fill-in a string variable in script?