I have a SP returning an unknown # of columns.
1st column is the time periods, 2022-07, 2022-08, etc
2nd and to many columns is for each line on the linechart I want to map.
eg: StarWars, Marvel, LOTRs, etc... could be more dont know what the values could be or how many.
The values of those columns is a int #. Example dataset.
Periods StarWars Marvel LOTRs
2022-07 120 50 110
2022-08 125 55 105
So how do I attach that to a line chart control? I have read thru the demo codes but none seem to give me the answer.
In my old days, :), I would return a dataset as structured above and then bind that control to the dataset.
Then set the bottom axis to the Periods column values and the Up axis to the values in the other columns.
With the legend using the column names.
Not sure how to describe that in the data class as I dont know the column names that could be coming in.
And not sure what the controls tags should be looking like.
Any help would be appreciated.
Thanks in advance.