I have a kendo chart I am using within a dashboard.
The definition of the chart contains a link to the data which is returned as a DataSource (using dt.ToDataSourceResult()) and is in the format.
Field 1, Field 2, Field 3
A, 1, 2
B, 2, 2
etc.
The series are defined as
series:[{field:"Field2",type:"x", categoryField:"field1",axis:"primary", name:"ABC" }
,{field:"Field3",type:"x", categoryField:"Field1",axis:"primary", name:"Contract Value" }]
where type is set to the series type.
In scenario 1, Field 1 is a date and we require Field 2 and 3 to each be a separately defined series (one being a bar and the other a line.) this works as we would like.
In scenario 2, Field 1 is a company name and Field 2 and 3 are again separately defined series but both bars. In this case the first series is shown as a bar but the second is missing, however the legend contains an entry for both. What is going wrong? If we change series 2 to a line it appears as before.
I understand we could reshape the data for every instance and have separate definitions but would rather have a single elegant solution.
Can you shed any light in what is happening?
Thanks