I have a dataset with three columns: [1] date and time; [2] temperature; and [3] humidity. I want the x-axis to be the date/time, but I cannot get EDT Advanced to recognize the format. I have tried several transformations but I can’t find one that is recognized by the Chart block.
I am including a few rows of my dataset. Any insight is greatly appreciated. I hope I am not overlooking something silly.
I tried to upload my .transform file but was not allowed as a new user.
In case you have a column including date and time it is interpreted as text for the x-axis.
The date format is only used for plain dates without time. Possible date formats are described in documentation, too (just check the the “?” (help) in the chart transformation.
And your example date doesn’t show any senseful charts even if you split out the dates only, as all dates are the same and chart transformation doesn’t know how to interpret identical dates.
I manipulated the dates and leave them in an own column
then it shows the above label format (I ignored the time). Date format is changed as I work on a German configured system. The resulting chart shows a minimum range of dates, which is more than in the data. See attached file
Top part is chart with dates as text format. Botton part use the dates only, were I manipulated the dates to be unique, just to show the functionality.
