Thanks for the reply, i have created the first graph getting the data from Mysql, the problem im having is with the drilldown,
i have linked my code snip of where im stuck,
https://drive.google.com/file/d/1qN8O0uUa_NeQHRjL9ULLSfSSRo4s5qdB/view?usp=sharing