RadHTMLChart Multiple Series from SQL

[Thomas Cornelio]

Hi,

I would like to plot a column chart similar to the one on your example : http://demos.telerik.com/aspnet-ajax/htmlchart/examples/charttypes/columnchart/defaultcs.aspx

In my case the X axis is the date and the Y axis is the Vehicle count as you can see from the attached image.

I am able to plot the date together with the vehicle count column on the Y axis as you can see on the attachment without any problems.

However i am unable to plot per day per the Nationality column as per my attachment with data. I am currently binding from SqlDataSource. 

In effect for each day i should have 5/6 different columns one per nationality.

Can you please assist as to how to accomplish this task?

Thanks.

[Danail Vasilev]

Hi Thomas,

It seems that you are trying to group the chart's data source. This feature is currently supported only by the RadChart and is illustrated in Grouping databound items help article.

Such an idea about the RadHtmlChart control has already been logged as a PITS item here, so that you can follow its progress cast you vote and/or leave a comment(e.g., how you would expect things to work).

For the time being you can manually group the data source of the chart, prior to binding it. Such an example is illustrated in the attached archive.

Regards,
Danail Vasilev
Telerik

[Tommy]

Danail, 

I am trying to use the example that you gave for grouping a dataset and I am having an issue with this line in the code.
//Split current datatable to multiple datatables
dtarr[i] = oldDT.Select("Nationality='" + distinctValues.Rows[i][0].ToString() + "'").CopyToDataTable();

There is no definition for CopyToDataTable().  Can you point me in the right direction for this.  

Thanks 
Tommy 

[Tommy]

I found the issue I was missing this reference. System.Data.DataSetExtensions

[Asutosh]

hi
i am using the above code
its work for me
bt hoe can i bind x-axis data in above code 
u didnt show that
i want to make stack bar chart dril-down 
for that i nedd x-Axis data 
how can i bind that in above code which u attached in zip

[Danail Vasilev]

Hello Asutosh,

The x-axis of the chart from the mentioned example is properly bound to the "YearMonth0" field from the data source. For example:

ASPX:

<telerik:RadHtmlChart ID="RadHtmlChart1" runat="server" Width="800" Height="500">
    <PlotArea>
        <XAxis DataLabelsField="YearMonth0">
            <LabelsAppearance RotationAngle="90">
                <TextStyle Bold="true" />
            </LabelsAppearance>
        </XAxis>
        <YAxis>
            <LabelsAppearance>
                <TextStyle Bold="true" />
            </LabelsAppearance>
        </YAxis>
    </PlotArea>
</telerik:RadHtmlChart>

You can make a test by running the provided example on 21-Jan-2014.

Regards,
Danail Vasilev
Telerik

 

 

[Danail Vasilev]

Hi All,

You can find the modified version of the RadHtmlChart's data source grouping example in the Group RadHtmlChart Data Source Code Library.

Regards,
Danail Vasilev
Telerik