asked on April 3, 2024
Hello support team,
I faced with an issue if I place numeric measure (Price for example) to rows, I get incorrect behavior. Drilldown doesn't work, breadcrumbs doesn't appears.
See an example https://jsfiddle.net/r3aubz4t/
Best regards,
Denis
⋅ April 4, 2024
Hello, Denis!
Thank you for reaching out to us.
Kindly note that the feature for drill-down in Highcharts was originally designed to work with string members. To overcome this limitation, we recommend using mapping - Flexmonster's feature that allows defining the type of fields. By setting the "Price" field type to string, you will be able to use the chart drill-down as shown in this JSFiddle.
Please let us know if the suggested solution would work for you.
Best Regards,
Maksym
⋅ April 8, 2024
Hello, Maksym
Thanks for the answer.
In my case I can't change type from number to string in pivot table.
Do you have a link to docs in Highcharts where I can find that the feature for drill-down was originally designed to work with string members? It will help me in negotiations with a customer. Thank you.
Also, I would like to highlight that I be able to build a drillable chart with numeric dimension in Highcharts.
https://jsfiddle.net/7d2rn0cb/
Thank you for help.
Best regards,
Denis
⋅ April 9, 2024
Hello, Denis!
Thank you for your reply.
Kindly note that in our previous response, we were referring to the limitation of our Highcharts connector while working with numeric values, not the Highcharts themselves. Due to the wide variety of available charts in Highcharts, the code of our connector cannot be universally applicable to all of them.
As a solution for your case with numeric field drill-down, we recommend preprocessing the data returned by Flexmonster Highcharts connector to make it compatible with the drill-down feature of Highcharts. After examining the chart data provided by our connector, we have discovered the mismatch of types of drill-down identifiers in series and drilldown. Due to this issue, the drill-downs cannot be mapped to the chart series. We recommend converting them to a single type, as is shown in a modified example from our previous response: https://jsfiddle.net/flexmonster/s4Ltq2hz/
Contrary to modifying the chart data provided by our Highcharts connector, you can also handle the column types more precisely while the Flexmonster data is converted to a format supported in Highcharts. You can either modify the Highcharts connector script (https://cdn.flexmonster.com/lib/flexmonster.highcharts.js) or implement the prepareDataFunction (see the use case example in this JSFiddle).
Please let us know if one of the provided solutions would work for your case.
Best Regards,
Maksym
⋅ April 24, 2024
Hello, Denis!
Hope you are doing well.
We are wondering if you had time to check the suggested solutions for implementing drillable bar charts using the Flexmonster Highcharts connector.
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ April 25, 2024
Hello Maksym
Thank you for another options. It seems like https://jsfiddle.net/flexmonster/s4Ltq2hz/ can be a solution. We have created a task in backlog. I will post the results when I take the task into development.
Thank you.
Best regards,
Denis
⋅ April 26, 2024
Hello, Denis!
Thank you for your response.
Our team is glad to hear that the proposed solution with data preprocessing worked for you.
Feel free to contact us if any other questions arise.
Best Regards,
Maksym
