Multiple drilldown highchart

Munir asked on June 21, 2019

Hello,
Is it possible to have multiple levels of drilldowns with the default highchart integration?
Like Color > Region > Category…
 
https://jsfiddle.net/flexmonster/qf73smhf/
 
Thank you

3 answers

Public
Tanya Gryshko Flexmonster June 21, 2019

Hello, Munir,
 
Thank you for your question.
 
We recommend using prepareDataFunction to preprocess the data in your own way. For more details, please check our documentation: https://www.flexmonster.com/doc/integration-with-highcharts/.
 
Also, we suggest ensuring that Highcharts support the functionality you described. 
 
Please let us know in case of any further questions.
 
Regards,
Tanya

Public
Munir June 26, 2019

Hello Tanya,
 
I’m looking for what your fiddle example do: https://jsfiddle.net/flexmonster/qf73smhf/
Which is drilldown from Color to Region.
 
I just want to continue with the drilldown, in other words, when click in a Color drilldown to Region, when click in Region drilldown to Category… and so on.
 
Is it possible or your integration only do one level of drilldown?
I tried to put the Category in columns, next to Region, but not worked:

pivot.highcharts.getData(
{
type: "bar",
withDrilldown: true,
slice: {
rows: [{uniqueName: "Color"}],
columns: [{uniqueName: "Region"}, {uniqueName: "Category"}, {uniqueName: "[Measures]"}],
measures: [{uniqueName: "Quantity"}]
}
},
createAndUpdateChart,
createAndUpdateChart
);
Public
Tanya Gryshko Flexmonster June 26, 2019

Hello, Munir,
Thank you for your reply and for sharing the additional details.

Our integration provides the data for one level of drill down. In case you want to get data for multiple levels, our suggested approach is using prepareDataFunction to preprocess the data.

The following information should help:

  1. https://jsfiddle.net/flexmonster/x0cqafqh/ – an example of how prepareDataFunction can be used
  2. https://www.flexmonster.com/api/getdata/ – the structure of data passed to the prepareDataFunction

Hope it helps.
Regards,
Tanya

Please login or Register to Submit Answer