Thomas Cornelio
Top achievements
Rank 1
Thomas Cornelio
asked on 20 Jan 2014, 11:19 AM
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.
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.
6 Answers, 1 is accepted
0
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
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
0
Tommy
Top achievements
Rank 1
answered on 06 Feb 2014, 02:53 PM
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
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
0
Tommy
Top achievements
Rank 1
answered on 06 Feb 2014, 03:21 PM
I found the issue I was missing this reference. System.Data.DataSetExtensions
0
Asutosh
Top achievements
Rank 1
answered on 21 May 2014, 07:49 AM
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
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
0
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:
You can make a test by running the provided example on 21-Jan-2014.
Regards,
Danail Vasilev
Telerik
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
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
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
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
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.