Use of Kendo's Pie chart with dynamic data

Question

i'm trying to use a pie chart to display statistics. Data is within my table and i get it this way:

public class StatisticsAccess
{
    public static object getTypesForStatistics()
    {
        var dbo = new UsersContext();
        var all = (from a in dbo.Note
                      select a).ToList();
        var results = all.GroupBy(item => item.language.lang)
                         .Select(g => new
                         {
                             language = g.Key,
                             Count = g.Select(l => l.language.lang).Count()
                         });
        return (results.ToList());

    }
}

Controller :

public ActionResult Index()
{
    var results = Json(DAL.StatisticsAccess.getTypesForStatistics());
    return View();      
}

View:

  @(Html.Kendo().Chart()
        .Name("chart")
                .Title(title => title
                    .Text("Share of Internet Population Growth, 2007 - 2012")
                    .Position(ChartTitlePosition.Bottom))
        .Legend(legend => legend
            .Visible(false)
        )
        .Series(series => {
            series.Pie(model => model.language, model => model.Count);
        })
        .DataSource(ds => ds.Read(read => read.Action("index", "Statistics")))
        .Tooltip(tooltip => tooltip
            .Visible(true)
            .Format("{0}%")
        )


    )

There are syntax errors in my view, in the series property:

Cannot convert lambda expression to type "string"

Can anyone explain me the syntax i shoud follow to fix this error ? Thx

score 2 · Accepted Answer · edited May 23 '17 at 11:58

2

I think you are doing the Count in your LINQ the wrong way.

Count = g.Select(l => l.language.lang).Count()

There is no need to do a Select here as they are already group from your .GroupBy

should be:

Count = g.Count()

Using GroupBy, Count and Sum in LINQ Lambda Expressions

edited May 23 '17 at 11:58

Community

1
1

answered May 21 '15 at 22:50

JFlox

688
3
12

Thanks, but it does not solve my problem with the chart. it still appears empty – FieryA May 26 '15 at 11:02
Are you forgetting to use your results as a parameter of View()? – JFlox May 26 '15 at 19:18

Use of Kendo's Pie chart with dynamic data

1 Answers1