DataViz chart aggregate function inlcuding data from previous month

[Chris]

Hi,

I'm building a basic line chart in Kendo UI Dataviz and I'm having a
problem with the aggregation method. The goal is to group my sales data
by month and aggregate the Sum(Amount) which seems to work in my chart
but I'm experiencing a bug that causes data from the first day of
October to be included in the sum for September. Oct 2 shows in October
but Oct 1 is included in September's total.

The data is:

10/1/2013 12:00:00 AM, 22964.5000

10/2/2013 12:00:00 AM, 6762.9400

Html.Kendo().Chart(Model)
.Name("revenue")
.Title("Revenue Activity by Month")
.Legend(legend => legend
.Position(ChartLegendPosition.Bottom)
)
.Series(series =>
{
series.Area(s => s.TotalRevenue, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Total Revenue").Color("#73c100");
series.Line(s => s.RevenueSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Subscriber Revenue");
series.Line(s => s.RevenueNonSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Non-Subscriber Revenue");
})
.CategoryAxis(axis => axis.Date()
.BaseUnit(ChartAxisBaseUnit.Months)
)
.ValueAxis(axis => axis
.Numeric("revenue")
.Labels(labels => labels.Format("{0:C}"))
.Line(line => line.Visible(false))
)
.Tooltip(tooltip => tooltip
.Visible(true)
.Format("{0:C}")
)

What I receive is a chart with two points on the X Axis. The first
point is Sept 2013 and includes $22,964. The second point is Oct 2013
and includes $6,762.

Any ideas would be greatly appreciated.

[Hristo Germanov]

Hi Chris,

Could you please give me the chart's data because I need to observe the problem locally?

Regards,
Hristo Germanov
Telerik

[Chris]

I've attached a sample that will allow you to recreate the error. In the first chart there are two data points for Oct - 10/1 and 10/2. The 10/1 metrics gets included in Sept revenue and the 10/2 included in October revenue. When I move both October metrics to 10/2 they are both included in October like they should be.

Thanks,
Chris

[Chris]

The forum page errored and did not include the attachment so I'm pasting it into this reply.
<%
        // in this example there are two revenue metrics for Oct. The metric for 10/1 is added to Sept, the metric for 10/2 is added to October
        var recs = new []
        {
            new { Date = DateTime.Parse("9/26/2013"), TotalRevenue = Decimal.Parse("276.5600"), RevenueSubscriber = Decimal.Parse("0.0000"), RevenueNonSubscriber = Decimal.Parse("276.5600") }
            , new { Date = DateTime.Parse("9/27/2013"), TotalRevenue = Decimal.Parse("3556.5313"), RevenueSubscriber = Decimal.Parse("0.0000"), RevenueNonSubscriber = Decimal.Parse("3556.5313") }
            , new { Date = DateTime.Parse("10/1/2013"), TotalRevenue = Decimal.Parse("23763.0400"), RevenueSubscriber = Decimal.Parse("23763.0400"), RevenueNonSubscriber = Decimal.Parse("0.0000") }
            , new { Date = DateTime.Parse("10/2/2013"), TotalRevenue = Decimal.Parse("21379.1400"), RevenueSubscriber = Decimal.Parse("21379.1400"), RevenueNonSubscriber = Decimal.Parse("0.0000") }
        };
    %>

    <%=
    Html.Kendo().Chart(recs)
        .Name("revenue")
        .Title("Revenue Activity by Month")
        .Legend(legend => legend
            .Position(ChartLegendPosition.Bottom)
        )
        .Series(series =>
                {
                    series.Area(s => s.TotalRevenue, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Total Revenue").Color("#73c100");
                    series.Line(s => s.RevenueSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Subscriber Revenue");
                    series.Line(s => s.RevenueNonSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Non-Subscriber Revenue");
                })
        .CategoryAxis(axis => axis.Date()
            .BaseUnit(ChartAxisBaseUnit.Months)
            )
        .ValueAxis(axis => axis
            .Numeric("revenue")
            .Labels(labels => labels.Format("{0:C}"))
            .Line(line => line.Visible(false))
        )
        .Tooltip(tooltip => tooltip
            .Visible(true)
            .Format("{0:C}")
        )
    %>
    <%
        // in this example I moved the both October revenue metrics to 10/2. the revenue showed up in October like it's supposed to
        recs = new []
        {
            new { Date = DateTime.Parse("9/26/2013"), TotalRevenue = Decimal.Parse("276.5600"), RevenueSubscriber = Decimal.Parse("0.0000"), RevenueNonSubscriber = Decimal.Parse("276.5600") }
            , new { Date = DateTime.Parse("9/27/2013"), TotalRevenue = Decimal.Parse("3556.5313"), RevenueSubscriber = Decimal.Parse("0.0000"), RevenueNonSubscriber = Decimal.Parse("3556.5313") }
            , new { Date = DateTime.Parse("10/2/2013"), TotalRevenue = Decimal.Parse("23763.0400"), RevenueSubscriber = Decimal.Parse("23763.0400"), RevenueNonSubscriber = Decimal.Parse("0.0000") }
            , new { Date = DateTime.Parse("10/2/2013"), TotalRevenue = Decimal.Parse("21379.1400"), RevenueSubscriber = Decimal.Parse("21379.1400"), RevenueNonSubscriber = Decimal.Parse("0.0000") }
        };
    %>
    <%=
    Html.Kendo().Chart(recs)
        .Name("revenue2")
        .Title("Revenue Activity by Month")
        .Legend(legend => legend
            .Position(ChartLegendPosition.Bottom)
        )
        .Series(series =>
                {
                    series.Area(s => s.TotalRevenue, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Total Revenue").Color("#73c100");
                    series.Line(s => s.RevenueSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Subscriber Revenue");
                    series.Line(s => s.RevenueNonSubscriber, categoryExpression: model => model.Date).Aggregate(ChartSeriesAggregate.Sum).Name("Non-Subscriber Revenue");
                })
        .CategoryAxis(axis => axis.Date()
            .BaseUnit(ChartAxisBaseUnit.Months)
            )
        .ValueAxis(axis => axis
            .Numeric("revenue")
            .Labels(labels => labels.Format("{0:C}"))
            .Line(line => line.Visible(false))
        )
        .Tooltip(tooltip => tooltip
            .Visible(true)
            .Format("{0:C}")
        )
    %>

[Hristo Germanov]

Hello Chris,

I tried to reproduce the problem - to no avail. I am sending my test project for your reference. Could you please examine it and try to reproduce the problem?

Regards,
Hristo Germanov
Telerik

[Chris]

I ran project and it worked. The only difference I could see between your project and mine was the library. I was using the 7.18 version. I undated project to use the newer library but the problem remains. This weekend I will further investigate and let you know what I find.
Chris