asked on April 11, 2018
Hi,
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
⋅ 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.
Regards,
Tanya
