Pivot non numeric value

Some of value on our CSV is sometime contain non numeric value i.e. “n/a”.
is it possible to pivot the value on the flexmonster?
for example,
the csv datasource is : https://cdn.aseanstats.org/public/data/csv/transport/ASE.TRP.ROD.ORT.019.csv
and result shall be : https://cdn.aseanstats.org/public/img/pivot_non_numeric.png

1 answer

Tanya Gryshko Flexmonster April 11, 2018

Hello, Riyan,
Thank you for posting to our Support Forum!
Non-numeric values are treated as null values and hidden intentionally. The reason for this is to avoid displaying too much empty rows when the data contains lots of such values.
For cases when null values are displayed, you can configure null values to be shown as n.a. Please refer to this sample and see how this can be done: http://jsfiddle.net/flexmonster/pz431qp5/33/. n.a for null values is set via number formatting at line 43.
Please let me know in case of other questions.

Please login or Register to Submit Answer