asked on June 21, 2018
Hi Team,
Please refer this fiddle https://jsfiddle.net/ganesh_modak_fis/byjtkxzL/103/
First import local csv using this data:
ds+Date;Minimum Value;Maximum Value;Value,
2018-06-21;100;1500;500,
2018-06-20;200;2000;1000,
2018-06-19;300;2500;700
and click "View Chart" button. We see captions as Minimum Value and Maximum Value
Now again import local csv using below data: (Minimum Value is empty)
ds+Date;Minimum Value;Maximum Value;Value,
2018-06-21;;1500;500,
2018-06-20;;2000;1000,
2018-06-19;;2500;700
Click on view chart, now min value caption changes to "Count of Minimum Value"
Even though I have configured aggregation: none for this measure.
Regards
⋅ June 21, 2018
Hi Ganesh,
Thank you for posting your question on the forum.
The case you described happens because there is no value for Minimum Value column in the first row. Thus, it’s field type is automatically assumed to be string. We recommend you specify the type for numeric Minimum Value column explicitly by adding "-" prefix to its title, as follows:
ds+Date;-Minimum Value;Maximum Value;Value
2018-06-21;;1500;500
2018-06-20;;2000;1000
2018-06-19;;2500;700
Please let me know if this works for you.
More information about data types in CSV can be found in the documentation: https://www.flexmonster.com/doc/managing-data-presentation-csv/.
Kind regards,
Iryna
⋅ June 22, 2018
Hi, this works. Thanks !
