Add horizontal line to a Scatter Plot at a calculated value (from Statistics View node) rather than inputting a number

Hi, I have built a very simple workflow analysing drug discovery assay data generated over time, with a simple scatter plot output for one key compound; date of screen on x axis and result son the y axis. I want to see how reproducible the results are over time, of there are any outlier experiments etc. I have added a Statistics View which calculates and displays the mean value (in this case 4.68). I then added a reference line to my plot and typed in 4.68 in the value field. As I add more data to the workflow, this average is going to change. The Statistics View calcualted average will auotmatically update (great!) but the vlaue of this line will not. Is there a way to point the value to the calculated average in the Statistic plot rather than manually type it in as it changes over time? (I’ll then add lots more lines to track standard deviation etc to my plot). Thanks for any help!

1 Like

Hello @HelenHarrison,

and welcome to KNIME Community!

Not exactly sure which nodes are you using but sounds you are looking for parametrization. Flow variables are intended for such use cases. In short you need to create flow variable for your mean (and later for other measures you want to use in visualization) and assign it in node behind reference line value. See here for more about flow variables and working with them:

Br,
Ivan

2 Likes

Thanks Ivan, I have generated a flow variable that equals my updated geomean value. I’m still stuck though. How do I get the scatter plot reference line to use this flow variable as the value? I can see now if I click on the little icon that looks like a square with a diagonal line running through I get a pop-up of “Overwrite with flow variable” which feels like what I want to do but it is greyed out and says “No suitable flow variable present”. Thanks for your help

1 Like

You are welcome. Probably type of the flow variable you have created is not the same as the one needed for scatter plot reference.
Ivan

2 Likes