I'm not sure if this is a problem, or a misunderstanding on my part, but there's an unexpected behavior with the aggregate function count on kendo charts while using dates. The issue is notable in this site's demo at :
http://demos.kendoui.com/dataviz/bar-charts/date-axis.html
The problem is that if you choose the base unit as days, the count aggregate function will instead show minimum value instead of counting how many registers for that day are there.
However, if you have at least 2 registers in any given day, the function will count correctly for that particular date.
To further demonstrate this behavior, modify this part of the demo's code:
There are now at least 2 registers for every day except December 30. The count is done correctly for every day except December 30, which shows the value.
http://demos.kendoui.com/dataviz/bar-charts/date-axis.html
The problem is that if you choose the base unit as days, the count aggregate function will instead show minimum value instead of counting how many registers for that day are there.
However, if you have at least 2 registers in any given day, the function will count correctly for that particular date.
To further demonstrate this behavior, modify this part of the demo's code:
function createChart() { $("#chart").kendoChart({ theme: $(document).data("kendoSkin") || "default", title: { text: "Units sold" }, series: [{ type: "column", data: [20, 40, 45, 30, 50, 10, 20, 30 ,40 , 50], aggregate: "sum" }], categoryAxis: { baseUnit: "months", categories: [ new Date("2011/12/30"), new Date("2011/12/31"), new Date("2012/01/01"), new Date("2012/01/02"), new Date("2012/01/03"), new Date("2011/12/31"), new Date("2011/12/31"), new Date("2012/01/01"), new Date("2012/01/02"), new Date("2012/01/03") ] } }); }There are now at least 2 registers for every day except December 30. The count is done correctly for every day except December 30, which shows the value.