Hey there,
I’m relatively new to Highcharts and have been tasked with creating dynamic highcharts using data from a SQL database. I’m able to create some charts, but I’m trying to figure out how to properly create the drilldown/drillthrough feature. From what I’ve seen in examples, drilldown data is embedded in the Highcharts build right from the beginning. It also appears that the drilldown is of the same style as the parent, i.e. a pie chart drills down to another pie chart.
What I would like to be able to do is create a Highchart with summary data pulling from SQL, then if you click on a point in the highchart, it will call and load a secondary javascript function that will call the drill down SQL stored procedure using point data and parameters from the original chart and generate a brand new Highchart.
An example would be a stacked column chart showing overall sales by location. If you click on the one of the bar points, it would load a pie chart showing the products sold for that location and time. The overall sales by location data is pulled from one stored procedure and the Products sold is another stored procedure with date and location pulled from the parent highchart fed in as parameter values.
Any advice would be greatly appreciated.
Thank you