K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Column Drilldown - Multi Categories and Series

Hello

I am new to the world of highcharts and was hoping some could help guide me to an outcome.

I am looking to create a Column Chart that I can drilldrown on.
I need to display Multiple categories and Multiple series at drilldown.

e.g. first level (Group)
and 2nd Level drilldown - Group 1 by Gender
Attachments
drill down.JPG
drill down.JPG (43.32 KiB) Viewed 1422 times
top level.JPG
top level.JPG (45.62 KiB) Viewed 1422 times
hubert.k
Posts: 1164
Joined: Mon Apr 11, 2022 11:48 am

Re: Column Drilldown - Multi Categories and Series

Hello K.T!
Welcome to our forum and thanks for contacting us with your question!

You can find our official demo with drill down in column type chart here: https://www.highcharts.com/demo/column-drilldown There is also a code of that example in JSFiddle.

There is also some information about drill down module in the documentation: https://www.highcharts.com/docs/chart-c ... /drilldown

Let me know if you have any further questions.
Best regards!
Hubert Kozik
Highcharts Developer
K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Re: Column Drilldown - Multi Categories and Series

Thank you for your prompt reply really enjoy your product so far

Thank you for your references I have been able to create a drill down using the same examples you have shown.
https://jsfiddle.net/apo39qns/

However my challenge is having multiple categories for each series.
can further assistance would be great.
hubert.k
Posts: 1164
Joined: Mon Apr 11, 2022 11:48 am

Re: Column Drilldown - Multi Categories and Series

K.T,
I am not sure if that's what you want to achieve, but if I understand you correctly, all you need to add is some more points and series, like in this demo: https://jsfiddle.net/BlackLabel/z46y3jbr/

If I misunderstood you, please provide me with some more information, about how would like it to work, maybe some gifs or images.

Regards!
Hubert Kozik
Highcharts Developer
K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Re: Column Drilldown - Multi Categories and Series

Hello

That is getting closer to what I am trying to achieve

However when I drilldown I need to carry the same categories "timepoint 1 and timepoint 2" to flow through from the top level to the drilldown.

So when I click on Group 1 on on either timepoint (category) I should see something like attached as we need to compare.
Giving me 1 drilldown per Series with displaying multiple categories.

I hope this is clearer.

Thank you so much for your support.
Attachments
drill down multi categories.JPG
drill down multi categories.JPG (28.09 KiB) Viewed 1400 times
K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Re: Column Drilldown - Multi Categories and Series

Actually I think I have worked it out
will post my results shortly
K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Re: Column Drilldown - Multi Categories and Series

Good news it is displaying as was hoping for can see it all here
https://jsfiddle.net/cypsqz73/


I do have one questions about the code i am using
Is there anyway you can see how I can set this drilldown Series data y: value as an array I am not having much luck

Code: Select all

series: [{
    name: "Gender",
    data: [{
      name: "Gender",
      y: 40,
      drilldown: 'Gender'
    }, {
      name: "Gender",
      y: 20,
      drilldown: 'Gender'
    },{
      name: "Gender",
      y: 33,
      drilldown: 'Gender'
    }]
  },
hubert.k
Posts: 1164
Joined: Mon Apr 11, 2022 11:48 am

Re: Column Drilldown - Multi Categories and Series

K.T,
Thank you very much for posting your results! It can be very helpful for some users, who may face the same issue as you.

Referring to your question about values in the array of values, not the array of objects. It can be done with some JS functions, you can check it in the demo below. First, I declared values in an array and then passed them to a custom function (97 and 100 lines) with a proper name of the series.

Demo: https://jsfiddle.net/BlackLabel/uLmh4wpq//

Let me know if that was what you were looking for.
Regards!
Hubert Kozik
Highcharts Developer
K.T
Posts: 50
Joined: Tue Aug 16, 2022 3:37 am

Re: Column Drilldown - Multi Categories and Series

Perfect thank you
hubert.k
Posts: 1164
Joined: Mon Apr 11, 2022 11:48 am

Re: Column Drilldown - Multi Categories and Series

You're welcome! In case of any further questions, feel free to contact us again.
Hubert Kozik
Highcharts Developer

Return to “Highcharts Usage”