Hi,
I need display 5 series in the Stacked Bar Chart.
I used the following code to generate the ItemDataSource. But I got some runtime errors. Anyone can help me on that?
I need display 5 series in the Stacked Bar Chart.
I used the following code to generate the ItemDataSource. But I got some runtime errors. Anyone can help me on that?
private List<
IEnumerable
<RFIAgingChartModel>> GetChartItemSource()
{
List<
IEnumerable
<RFIAgingChartModel>> lstChartData = new List<
IEnumerable
<RFIAgingChartModel>>();
// series 1 -- <
14
days
IEnumerable<RFIAgingChartModel> lstSeries1 = context.RFIAgingChartModels;
context.Load(context.GetHeadContractSeriesDataQuery(596, "Head_LT14d"));
// series 2 -- > 14 <
28
days
IEnumerable<RFIAgingChartModel> lstSeries2 = context.RFIAgingChartModels;
context.Load(context.GetHeadContractSeriesDataQuery(596, "Head_14-28d"));
// series 3 -- > 1 month
IEnumerable<
RFIAgingChartModel
> lstSeries3 = context.RFIAgingChartModels;
context.Load(context.GetHeadContractSeriesDataQuery(596, "Head_1-2m"));
// series 4 -- > 2 months
IEnumerable<
RFIAgingChartModel
> lstSeries4 = context.RFIAgingChartModels;
context.Load(context.GetHeadContractSeriesDataQuery(596, "Head_2-3m"));
// series 5 -- > 3 months
IEnumerable<
RFIAgingChartModel
> lstSeries5 = context.RFIAgingChartModels;
context.Load(context.GetHeadContractSeriesDataQuery(596, "Head_GT3m"));
lstChartData.Add(lstSeries1);
lstChartData.Add(lstSeries2);
lstChartData.Add(lstSeries3);
lstChartData.Add(lstSeries4);
lstChartData.Add(lstSeries5);
return lstChartData;
}
private void RenderChart()
{
SeriesMapping sm1 = new SeriesMapping();
StackedBarSeriesDefinition d1 = new StackedBarSeriesDefinition();
d1.StackGroupName = "Stack1";
sm1.SeriesDefinition = d1;
sm1.LegendLabel = "Stacked Bar 1";
sm1.CollectionIndex = 0;
sm1.ItemMappings.Add(new ItemMapping("Week", DataPointMember.XValue));
sm1.ItemMappings.Add(new ItemMapping("Volume", DataPointMember.YValue));
SeriesMapping sm2 = new SeriesMapping();
StackedBarSeriesDefinition d2 = new StackedBarSeriesDefinition();
d1.StackGroupName = "Stack1";
sm2.SeriesDefinition = d2;
sm2.LegendLabel = "Stacked Bar 2";
sm1.CollectionIndex = 1;
sm2.ItemMappings.Add(new ItemMapping("Week", DataPointMember.XValue));
sm2.ItemMappings.Add(new ItemMapping("Volume", DataPointMember.YValue));
SeriesMapping sm3 = new SeriesMapping();
StackedBarSeriesDefinition d3 = new StackedBarSeriesDefinition();
// d1.StackGroupName = "Stack1";
sm3.SeriesDefinition = d3;
sm3.LegendLabel = "Stacked Bar 3";
// sm1.CollectionIndex = 0;
sm3.ItemMappings.Add(new ItemMapping("Week", DataPointMember.XValue));
sm3.ItemMappings.Add(new ItemMapping("Volume", DataPointMember.YValue));
SeriesMapping sm4 = new SeriesMapping();
StackedBarSeriesDefinition d4 = new StackedBarSeriesDefinition();
// d1.StackGroupName = "Stack1";
sm4.SeriesDefinition = d4;
sm4.LegendLabel = "Stacked Bar 5";
// sm1.CollectionIndex = 0;
sm4.ItemMappings.Add(new ItemMapping("Week", DataPointMember.XValue));
sm4.ItemMappings.Add(new ItemMapping("Volume", DataPointMember.YValue));
SeriesMapping sm5 = new SeriesMapping();
StackedBarSeriesDefinition d5 = new StackedBarSeriesDefinition();
// d1.StackGroupName = "Stack1";
sm5.SeriesDefinition = d5;
sm5.LegendLabel = "Stacked Bar 5";
// sm1.CollectionIndex = 0;
sm5.ItemMappings.Add(new ItemMapping("Week", DataPointMember.XValue));
sm5.ItemMappings.Add(new ItemMapping("Volume", DataPointMember.YValue));
RadChart1.SeriesMappings.Add(sm1);
RadChart1.SeriesMappings.Add(sm2);
RadChart1.SeriesMappings.Add(sm3);
RadChart1.SeriesMappings.Add(sm4);
RadChart1.SeriesMappings.Add(sm5);
RadChart1.ItemsSource = GetChartItemSource();
}