Get Free Trial

Get correct percentage data

Answered
Denis asked on May 19, 2021

Hi support team,
 
I faced with an issue of getting percentage data from the pivot table for Highcharts.
In this example If you applied format as percent for metric using Number formatting popup format applied correctly. But in the chart you will see wrong data (without multiplying by 100). Otherwise, if you apply percentage aggregation for the same column, then the data will be correct in the chart.
If you switch to flexmonster charts on the example (with applied percentage format) you will see correct percentage data.
Please see the screenshot. So I thing this is a bag for preparing data for Highcharts.
 
Best regards,
Denis

Attachments:
Screenshot.png

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 20, 2021

Hello,

Thank you for reaching out to us.
 
We want to confirm that the raw data is passed to the chart without any formatting applied.
As a workaround for your case, we suggest creating the calculated measure that would multiple “Price” by 100 and building a chart based on this measure.
Please see the JSFiddle demonstrating this approach: https://jsfiddle.net/flexmonster/c4n375e0/.
 
Do not hesitate to reach out if other questions arise.
 
Kind regards,
Illia

Public
Denis May 25, 2021

Hello Illia,
 
Thanks for the solution. But calculated measure is not suitable for us. We are expected correct value just after applying Format as present. As an option we can check format object and aggregation (if isPercent and not percent aggregation then multiply by 100).
 
And I would like to ask why do you have the difference in providing values to Highcharts and to your own charting framework? 
 
Thanks a lot.
 
Regards,
Denis

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 26, 2021

Hello, Denis,
 
Thank you for your feedback.
 
If creating a calculated value is not an option for you, we want to confirm that adjusting values based on the received formatting can be used instead.
 
Concerning the difference between providing the data to built-in and third-party charts.
For built-in charts, the data is coming directly from the internal structure with all the formatting applied. In fact, only its representation is changed to match the current chart type.
In its turn, third-party charting libraries expect custom data format and formatting options. This is why Flexmonster needs to preprocess its internal data structure and transmit the data to the charting library in the expected format.
 
We hope it helps.
Feel free to contact us if any other questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer