Stacked columns and Dates

[Darijo]

Hi,

It seems that I just cannot get beyond this issue.This is an example of dataset:[
{ type: "FOO", date: 1396952060722, count: 3 },
{ type: "BAR", date: 1396952060722, count: 2 },
{ type: "FOO", date: 1396952060722, count: 4 },
{ type: "BAZ", date: 1396952060722, count: 1 },
{ type: "FOO", date: 1396952060722, count: 3 },
{ type: "FOO", date: 1396952060722, count: 3 }
]
How can I make stacked column chart where X axis holds dates and columns are stacked bytype with count fields summed (Y axis) if they fall under the same date. I also need a way to regulate date granularity (year/month/day) and the data should distribute accordingly.Is there a buildin way to do this or I'll have to make complex data transform?

This is really important feature for us and I want to take advantage of every Kendo feature as much as possible so I can justify possible purchase.

Thanks.

[T. Tsonev]

Hi,

You should be able to achieve the described scenario with built-in features.

The Chart supports aggregating date series into specified "base units" (days, weeks, etc.). Series can also be grouped by a specified field.
By combining these features we get:

    $("#chart").kendoChart({
      dataSource: {
        data: [
          { type: "FOO", date: 1396952060722, count: 3 },
          { type: "BAR", date: 1396952060722, count: 2 },
          { type: "FOO", date: 1396952060722, count: 4 },
          { type: "BAZ", date: 1396952060722, count: 1 },
          { type: "FOO", date: 1396952060722, count: 3 },
          { type: "FOO", date: 1396952060722, count: 3 }
        ],
        group: {
          field: "type",
          dir: "asc"
        }
      },
      series: [{
        field: "count",
        categoryField: "date",
        stack: true
      }],
      categoryAxis: {
        type: "date",
        baseUnit: "auto" // "hours", "days", "weeks", etc.
      }
    });

-- Live demo --

I hope this helps.

Regards,
T. Tsonev
Telerik