Plot graph to be see that is interactive and updated every week

#1

Hi,
i would like to plot in X axis FY_FW and on the Y axis Response and with object as variable to colour the plots. what is the best way to do that?
Regards
Pio

Knime_question_plot.xlsx (3.5 KB)

0 Likes

#2

Hi,
please see attached workflow for an example for a scatter plot and a line plot from your data.
Kind regards
Alexander
Plots.knwf (29.5 KB)

2 Likes

#3

Hi @AlexanderFillbrunn Thank You.
would i be able to publish this result in a webpage?
Every week I will have more that will append to the former data so this plot will still be valid?
Regards
Pio

0 Likes

#4

Hi,
if you simply append the data to your Excel file and run the workflow again, this works. But be aware that I just extract the week from FY_FW, so it will only work for a single year. Otherwise you have to somehow incorporate the year into your x-axis as well. You can use the Image Writer (Port) to save the image in SVG format. You may have to enable “Generate Image at Outport” in the settings of the visualization node first.
Kind regards
Alexander

2 Likes

#5

Hi AlexanderFillbrunn.
Thanks very much. I will try it out

0 Likes