Chart measure label changes to "Count of [name]" when there is no data for that measure

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

2 answers

Public
Iryna Kulchytska Flexmonster 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/data-types-in-csv/.
 
Kind regards,
Iryna

Public
Ganesh Modak June 22, 2018

 Hi, this works. Thanks !

Please login or Register to Submit Answer