Can you group on a graph using different dataSets?
Posted on 2013-02-06
Hi Experts, I have an unusual problem where I need to create a line graph comparing different dates of data. Problem is that each date is retrieved using a different dataset. The reason for this is that the "where" clause I use goes via a special odbc diver to the database. So I can only use one date retrieval per dataset.
At the moment I am using the first dataset to retrieve the first data points. I then use the second, third etc data points using the lookup feature.
This works fine for plotting each DataSet information as a line graph Horizontally E.g. The line represents 1 DataSet of information. However what I want to do is have each dataSet grouped long the X axis, so one line on the graph would represent many dataset data points.
I hope that makes sense. Firstly do you think this is possible and secondly how would I do this. Please let me know if I need to explain further.