topic Re: Adding row values based on graph selection in Discussions

Adding row values based on graph selection

Ohad_s — Sun, 24 Aug 2025 07:15:44 GMT

Hi,

I have data that is spread over serval positions (X\Y).

I would like to plot the data on graph builder, mark set of data (based on the position) and for this selected rows add new value in different column.

for example, add new column "Group" and for the selected rows give the value "a1".

currently, I am using one of two methods: lag function, or recode for X and then Y and concatenate the new values.

but I would like a more "visualized" based approach.

Thanks for any help or advice.

Re: Adding row values based on graph selection

dlehman1 — Sun, 24 Aug 2025 11:09:54 GMT

You may be looking for a more automated (JSL) way to do this, but if you just want to do what your example shows, after selecting the points on the graph go to Rows - Select where - Name selection in column and call the column Group and enter a1 for the selected rows. I'm not sure if you want the unselected rows identified as a different group label or left missing, but you can decide what to enter for the unselected rows. This method requires you to manually select the rows from the graph, so that is why I don't consider it an automated method.

Re: Adding row values based on graph selection

txnelson — Sun, 24 Aug 2025 21:19:53 GMT

Here is a simple example using a script to display a window that will set the value of a column called Group for all selected rows to whatever value is input

Names Default To Here( 1 );

nw = New Window( "Set Values",
	V List Box(
		H List Box(
			Text Box( "Enter Value to Set" ),
			neb = Number Edit Box( . )
		),
		sv = Button Box( "Click to Set Value",
			If(
				Length(
					Current Data Table() <<
					get selected rows
				) > 0,
				:Group[Current Data Table() <<
				get selected rows] = neb << get
			)
		)
	)
)

;

Re: Adding row values based on graph selection

Ohad_s — Wed, 27 Aug 2025 09:15:47 GMT

thank for your response.

this is what I was wanted!

This is not automated, but based on data visualization which is what i was looking.

Re: Adding row values based on graph selection

Ohad_s — Wed, 27 Aug 2025 09:22:03 GMT

thank you for your replay.

this script is a nice approach to add values to selected rows.