asked on March 30, 2018
Just wanted some pointers around
Have gone through the existing docs specially this one https://www.flexmonster.com/doc/integration-with-any-charting-library/
Will appreciate any additional pointers.
⋅ March 30, 2018
Hello, Umar,
Thank you for the interest in pivot table integration with charting libraries.
Check a live demo where data from Flexmonster is used to draw a simple bar chart via ECharts library: https://jsfiddle.net/flexmonster/55wgu8kw/.
In the method prepareDataFunction (line 31) you can see how data from pivot table is preprocessed to the format that suits the ECharts library.
Please let me know if this sample was helpful for you.
Regards,
Tanya
⋅ March 30, 2018
Hi Tanya,
Thank you for your response.
I have used prepareDataFunction a couple of time before as I have used it along side google charts.
I am looking for solutions for specific use cases such as drill up and drill down and visualisation of the X axis labels to be more intuitive. You can go through this JSfiddle https://jsfiddle.net/70mtbubx/15/. The challenge in this example is when I drill down from category to countries the label on the X axis do not make much sense as the hierarchy is not displayed.
Apart from the the above challenges would appreciate any additional pointer that I need to keep in mind while making this echart integration open source library.
Regards,
Umar
⋅ March 30, 2018
Hello, Umar,
Thank you for updating us.
To achieve hierarchical display of data on charts, you need to check if ECharts support the functionality you described. Please check if they have simple samples with just ECharts and static data organized hierarchically, without our component. Then you will be able to modify prepareDataFunction to achieve the same with the pivot table.
Please let me know about the results.
Regards,
Tanya
