Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to apply formatting values from pivot table to highchart?

Answered
Denis asked on April 17, 2020

Hello,
We integrate flexmonster with Highcharts and we have requirements to apply format cells (text align, thousand separator, decimal separator, decimal places, currency symbol, null value, format as percent) and probably conditional formatting from pivot table to metrics on highcharts (axes and tooltips). 
Could you suggest methods/approaches for solving this problem?
Best Regards,
Denis

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 17, 2020

Hello, Denis,
 
Thank you for writing to us.
 
Our team would like to kindly explain that being used as a data provider for Highcharts, Flexmonster can pass the limited number of properties allowing to define the listed adjustments. The whole list of such properties can be found in our documentation dedicated to the integration with Highcharts.
 
If the built-in connector to Highcharts does not include the necessary type of chart or if you need to preprocess the data differently, we recommend modifying the data object in an appropriate way or use the prepareDataFunction for deep customization.
 
The data object passed to Highcharts has the structure of the chart object described in Hightcharts API Reference. It means it can be modified in the desired way before being passed to the handler.
 
The prepareDataFunction allows to fully rebuilt the data object using row data received by the component. You are welcome to check out an example demonstrating the result that can be achieved using the mentioned function.
 
In order to get the current configuration of the component in order to apply it to the chart using one of the approaches provided above, Flexmonster provides the set of corresponding API calls.
 
For example, the number formatting of the specific measure can be retrieved using the getFormat method, as well as its conditional formatting: getCondition.
Please find out more about named API calls from our documentation:

 
We hope it helps.
You are welcome to contact us in case other questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer