Unrelated series in the same chart

[Sylvain]

Hi,

 

I have a chart displaying the number of firm and speculative hours (area series). To do this, I retrieve my data from my controller and apply a grouping on the type (firm or speculative) and display stacked series using:

series.Area(model => model.Loe).Name("#= group.value #").CategoryField("YearMonth").Stack(true);

 

All work well but now, I want to add a new series displaying the work force(Data come from the same source) using:

series.Line(model => model.Capacity).Name("Capacity").CategoryField("YearMonth").Aggregate(ChartSeriesAggregate.Sum);

 

but the new series are added for each group. What I want is the new series appears only 1 times not for each group.

How I can do this?

 

Sylvain

[Tsvetina]

Hello Sylvain,

When you apply grouping in the Chart DataSource, it groups the entire data, so all series that you add to this Chart will display grouped. You can instead consider re-working the data on the server to have one data point per YearMonth value and place both the firm and speculative hours values in the same data point to avoid the need to apply grouping in the Chart DataSource.

Regards,
Tsvetina
Progress Telerik