Kendu Donut asp.net core Group and Aggregate

[Dave]

I am trying to aggregate my chart data but having no luck, I can do this using jqery version but not the .net core verion.

date is coming from a view model:
DataValue
DataCategory
DataColour

I have multiple entries so I need to sum the DataCategory up.

Ive been trying aggregates.Add and groups.add to the data source but ive had no luck getting the chart to display correctly.

@(Html.Kendo().Chart(Model.ChartSetup)
            .Name(@"ChartName")

            .Series(series =>
            {

                series.Donut(model => model.DataValue, categoryExpression: model => model.DataCategory).ColorField("DataColour")

             .Overlay(o => o.Gradient(ChartSeriesGradient.None))

                .Labels(labels => labels
                .Position(ChartBarLabelsPosition.OutsideEnd)

                .Visible(false)

                      .Template("#= category # - #= kendo.format('{0:P}', percentage)#")
                );
            })


            )

[Aleksandar]

Hi Dave,

I can suggest referring to the Binding to Remote Data Demo for the Donut Chart as it demonstrates how to configure the grouping in the DataSource:

.DataSource(ds => ds
            .Read(read => read.Action("_WorldScreenResolution", "Donut_Charts"))
            .Group(group => group.Add(item => item.Year))
            .Sort(sort => sort.Add(item=> item.OrderNumber)))

Make sure to click on the View Source tab to review the complete source code behind the demo.

Regards,
Aleksandar
Progress Telerik