I'm trying to get a Line Plot from my data. The data consists of Date (date), Name (string) and value1 (double) and value2 (double). And I would like to see the development of the two values in dependency of the date (Date x-axes, value y-axes). Like development of share prices.
Yes, it is. You may want to use the Mask Time and/or Time To String node and then convert the column into a row id using the Row ID node. The Line Plot can then be used to display value1 and value2 against the row id (date/time).
If you have your data rowwise you may need to traspose.
There is a node called transpose sth...
With the node lineplot you can only show columns as time series. Each column gets its name by the name, so you can set a new id with the rowID node first.
However all these line plot nodes make quite ugly plots with a horrible axis describtion. Therefore you could use the R-view node and call some nice libraries in R.
thanks for the additional info. I'm not yet familiar with R but I'll give it a try later. for now the solution with the date as row id has to be enough.
The scatter plot will give you scaling correctly, but obviously no lines, just a scatter.
This does seem somewhat of a limitation of the Line Plot viewer which forces the use of the RowID as the x-axis thereby not being able to specify a String or Double value column.