Duplicate but different Cat Axis items

[Ed]

I have a column chart where the data coming from the DB has some valid data that confuses Kendo. The data for the Category Axis is a list of merchants. There happens to be a few merchants with the exact same name, but different merchant IDs. How can I show "duplicate" merchant names in the category axis? Is there a way to identify uniqueness by the merchant id and not the merchant name, where merchant name is displayed on the category axis?
Thanks,
--Ed

[EZ]

If your data looks something like this:

 

[ {
               "merchant": "Acme",
               "id": "1",
               "value": 3,
               "userColor": "#ffd600"
           }, {
               "merchant": "Acme",
               "id": "2",
               "value": 7,
               "userColor": "#ffd600"
           }, {
               "merchant": "merch 2",
               "id": "3",
               "value": 12,
               "userColor": "#ffd600"
           }, {
               "merchant": "merch 3",
               "id": "4",
               "value": 15,
               "userColor": "#ffd600"
           }, ...

 

Then the chart will show similarly named categories with no problems:

 

Dojo DEMO

[T. Tsonev]

Hello,

Using a categoryAxis.field will deal with duplicate category names, as shown by Erik. In this mode categories and series points will be listed in order.

If series.categoryField is in use then duplicate categories will be merged. Series points will be aggregated accordingly. This is mostly useful when the series are bound from different data sets that have categories in common.

Regards,
T. Tsonev
Telerik

 

 

[Ed]

Hello,

Yes, you are correct that series.categoryField is in use and this is why the duplicate categories are merged based on category name. How can I specify unique categories based on a field other than what is displayed on the chart? I want to merge duplicate categories based on one field (let's say it is CategoryId) and display the categories on the chart using a second field (let's call it CategoryName).

Thanks,

--Ed

[T. Tsonev]

Hello Ed,

You can specify any field for the category binding. What appears on screen can be customized via templates:

categoryAxis: {
  labels: {
    tempate: "#= dataItem.myRealCategory #"
  }
}

I hope this helps.

Regards,
T. Tsonev
Telerik