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 get aggregated formats?

Answered
Ravi asked on February 27, 2020

Dear Team,
We are using our pivot grid with highcharts. in the pivot table we are using aggregation and the values are looks good in both grid and charts. but the cell formats are missing while ploting into highchart. i just appended the link to understand the issues. 
https://jsfiddle.net/ravimarch7/7wqsmju1/2/

 slice: {
rows: [{
uniqueName: "Country"
}, {
uniqueName: "[Measures]"
}],
columns: [{
uniqueName: "Category"
}],
measures: [{
uniqueName: "Price",
aggregation: "percentofcolumn"
}]
}

Please check the Price Measure in both charts.

Please provide helpfull solution to overcome this problem.
Thanks Again!!!

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 27, 2020

Hello, Ravi,
 
Thank you for your question.
 
The connector for Highcharts has several functions for defining number formatting. All these functions take the pivot table format object and return the formatting string in Highcharts format.
Detailed information about functions and the way to use them can be found in our documentation dedicated to the integration with Highcharts.
 
We have modified the JSFiddle you have provided us with using the mentioned functions so the formatting is applied both for Flexmonster in-built charts and the chart created by Highcharts.
 
Please note that the formats property of the report object is specified in the example. It serves to store information about the way numeric values are formatted in the component. In the example, it is also used as storage for formatting passed to Highcharts:

pivot.highcharts.getAxisFormat(rawData.meta.formats[0])

More information about the format object and its properties can be found following the link: Format Object.
 
We hope it works for you.
 
Do not hesitate to contact us in case of additional questions.
 
Kind regards,
Illia

Please login or Register to Submit Answer