Need a special offer?Find out if your project fits.
+

Build Drillable bar chart with numeric measure in Rows

Answered
Denis 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

3 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
Denis 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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Please login or Register to Submit Answer