Hi team,
I came to some troubles of rendering an aggregated chart, for example we have data like
{
"items": [
{
"site": "A Site",
"month": "2019-01-01",
"value": 20
},
{
"site": "B Site",
"month": "2019-01-01",
"value": 30
},
{
"site": "C Site",
"month": "2019-01-01",
"value": 10
},
{
"site": "A Site",
"month": "2019-02-01",
"value": 23
},
{
"site": "B Site",
"month": "2019-02-01",
"value": 34
},
{
"site": "C Site",
"month": "2019-02-01",
"value": 15
}
],
"count": 6
},
And I want to present the sum of all sites on each month, for column chart, I can use
<EjsChart>
<EjsDataManager Url="@URL" Adaptor="Adaptors.WebApiAdaptor" Offline="false"></EjsDataManager>
<ChartPrimaryXAxis ValueType="Syncfusion.EJ2.Blazor.Charts.ValueType.Category"></ChartPrimaryXAxis>
<ChartSeriesCollection>
<ChartSeries XName="month" YName="value" Type="ChartSeriesType.StackingColumn">
</ChartSeries>
</ChartSeriesCollection>
</EjsChart>
as a workaround, but if I want to show an aggregated line chart, that trick won't work.
Could you provide me an example as adding some Query attributes to ChartSeries to aggregate the value over all sites?
Regards
