Bar chart dynamic series

[Arun Kumar]

Hi All,

I have the following data (City, Description, Counts) returned from database

City,            Description,      Counts
Beirut Desc - 1 10000
Beirut Desc - 2 100
Beirut Desc - 3 5
Beijing   Desc - 1 90
Japan Desc - 3 2
Singapore   Desc - 2 2300
.....

Here not always all city will load. Based on some filters data is populated.

I want to show Description in xcategory and Counts in YValue and city will be series and legend value.

I am using group description based on city but its not giving correct result. Also I tried to add series based on cities but that also not working (showing all description as same value (i.e) first series value). 

How do I create bar chart for this?

Thanks.

[Missing User]

Hello Arun Kumar,

You can use SeriesMapping.GroupingSettings to group the data by City. You also need to set the Description field as XCategory DataPointMember. For example:

<telerik:RadChart x:Name="radChart">
    <telerik:RadChart.SeriesMappings>
        <telerik:SeriesMapping>
            <telerik:SeriesMapping.SeriesDefinition>
                <telerik:BarSeriesDefinition />
            </telerik:SeriesMapping.SeriesDefinition>
            <telerik:SeriesMapping.GroupingSettings>
                <telerik:GroupingSettings ShouldCreateSeriesForLastGroup="True">
                    <telerik:GroupingSettings.GroupDescriptors>
                        <telerik:ChartGroupDescriptor Member="City"/>
                    </telerik:GroupingSettings.GroupDescriptors>
                </telerik:GroupingSettings>
            </telerik:SeriesMapping.GroupingSettings>
            <telerik:SeriesMapping.ItemMappings>
                <telerik:ItemMapping DataPointMember="YValue" FieldName="Counts" />
                <telerik:ItemMapping DataPointMember="XCategory" FieldName="Description" />
            </telerik:SeriesMapping.ItemMappings>
        </telerik:SeriesMapping>
    </telerik:RadChart.SeriesMappings>
</telerik:RadChart>

and the code-behind:

List<MyDataItem> data = new List<MyDataItem>()
{
    new MyDataItem() {City = "Beirut", Counts = 10000, Description = "1"},
    new MyDataItem() {City = "Beirut", Counts = 100, Description = "2"},
    new MyDataItem() {City = "Beirut", Counts = 5, Description = "3"},
    new MyDataItem() {City = "Beijing", Counts = 90, Description = "1"},
    new MyDataItem() {City = "Japan", Counts = 2, Description = "3"},
    new MyDataItem() {City = "Singapore", Counts = 2300, Description = "2"}
};

radChart.ItemsSource = data;

public class MyDataItem
{
    public string City { get; set; }
    public string Description { get; set; }
    public double Counts { get; set; }
}

For additional information on grouping functionality, please refer to the following help topic:
http://www.telerik.com/help/silverlight/radchart-features-grouping-and-aggregation.html

I hope that this helps.

Kind regards,
Polina
the Telerik team