AnsweredAssumed Answered

Chart tool misinterprets delimited data formatted as percentage

Question asked by comment on Mar 14, 2019
Latest reply on Mar 18, 2019 by TSGal

The chart tool has the option to format Y-axis data as Percent. When this option is selected, the value of .65 will be displayed as 65%, and the Y axis ticks will go from 0% to 100%. This is true when the data source is the current found set - i.e. when the the data is coming directly from the fields in the records of the current found set.

 

However, when the same data is input to the chart as a return-separated list - i.e. the selected data source is 'Current Record (delimited data)' - the value of .65 is displayed as 0.65%, and the Y axis ticks go from 0% to 1%:

 

 

 

A file showing the problem is attached.

Outcomes