This pull changes the way that A. data is parsed and B. adds the ability to have numeric xAxes.
A. Where you'd have to specify "date" or "year" in the first cell of your data for Chartbuilder to cast your data as a timeseries now Chartbuilder just tries to guess at first and allows you to specify if you want something different or it gets it wrong. The logic is as follows:
If there is a specifed data type, parse the data as that data type and be done
If their is no specified data type test if the first column successfully parses as numbers
If the first column doesn't parse as numbers, test if it parses as dates
If the first column successfully auto-parsed as numbers but the range of those numbers is between 1500 and 3000 reparse as dates
If the first column doesn't parse as dates or numbers leave as strings
B. When you now specify your data as being numeric or the data is determined to be numeric by the logic above the xAxis will become a linear scale and the interface to adjust the parameters of that axis will appear in the editor. You can adjust the max, min, number of ticks and precision of the axis as well as add a prefix and suffix to label it. Currently the automatic spacing and tick value selection of the xAxis is non existent. There are also no mobile overrides presently.
This pull changes the way that A. data is parsed and B. adds the ability to have numeric xAxes.
A. Where you'd have to specify "date" or "year" in the first cell of your data for Chartbuilder to cast your data as a timeseries now Chartbuilder just tries to guess at first and allows you to specify if you want something different or it gets it wrong. The logic is as follows:
B. When you now specify your data as being numeric or the data is determined to be numeric by the logic above the xAxis will become a linear scale and the interface to adjust the parameters of that axis will appear in the editor. You can adjust the max, min, number of ticks and precision of the axis as well as add a prefix and suffix to label it. Currently the automatic spacing and tick value selection of the xAxis is non existent. There are also no mobile overrides presently.