Chart or Line Plot

KNIME Analytics Platform
#1

Hi,

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.

Is this possible?

regards

christel 

#2

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).

#3

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.

#4

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.

#5

Hi !

Thanks for these informations, that helped me well... but still, I have a problem.

My values in the RowID are not equally distanced ; for instance, I have :
Col0 = [0, 1, 4, 6]

When I display the plot, the values in the x axes are not scaled... so the shape of the plot is not good.

I have something like :

0----1----4----6

But I was expecting something like :

0----1--------------4---------6

#6

Nobody knows ?

I can add some precisions :

If I had two columns like this

x;y
0;0
1;1
2;4
4;16
10;100

and I want to plot y = f(x).

So, I'm expecting something like this : http://img600.imageshack.us/img600/7150/knime003.png

And KNIME gives me this : http://img855.imageshack.us/img855/2250/knime004.png

Can you see the difference on the x axes ? KNIME doesn't respect the distance between the points.

#7

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.

Simon.