user wants a chart to show the records in a table. the tables structure is quite simple:
date, value1, value2,... value10
a date and then 10 numbers, the numbers are not in any order and that is fine. they max out at 200.
11/01/23, 101, 12, 32, 157, 1, 77, 18, 182, 45, 133
11/02/23,....
11/03/23,...
in a mock up of the chart i put the series titles as the date and the data values i entered all down in 10 rows and showed him the sample and he said that was exact what he wanted. now in my dataset query i am pulling * with date range but now matter what i try to do in the dbchart i cant seem to replicate.
there is no correspondence between the numbers start/end from date to date. even if the numbers are the exact same and in the same order then so be it.
select * from table1 is basic query with a date range and that is working fine just not sure how to tie that data into the chart to get the same results.