topic Re: Data visualisation info Graph with two curves displaying point without changing data table in Discussions

Data visualisation info Graph with two curves displaying point without changing data table

ivomdb — Wed, 10 Oct 2018 18:36:56 GMT

Hi All

I am trying to find a way of producing a graph with two curves with different Y columns but same X column. However, for one curve I only want to show certain X values while for the other I want to keep it unchanged showing every single value.

IN excel I usually apply a filter to the same column of X and selelect the rows I wish to show. Then I change the curve I want to display all the values to be displayed as smooth Line while the other curve I displayed as plots.

I have tried the data filter but it only works for ranges and only allows one filter per column. I also though of selecting the Xs that I want to show on the data table but then I am not able to change the properties of each. I have tried using Graph Builder and also the Legacy Overlay.

As an example is if you use the data libbrary file Amplitude 100 and try to plot for the same X both Y and Amplitude. Under graph builder I would put the Y and Amplitude as Ys and X as X. However, I am not able to make one curve showing in data points only and the other showing smoother.

Also, if I select on the data table certain X values to be displayed it will apply the same to both curves.

I hope it is clear.

Any help is much appreciated.

Re: Data visualisation info Graph with two curves displaying point without changing data table

dale_lehman — Wed, 10 Oct 2018 21:03:37 GMT

I'm not entirely sure what you are asking, but you might try doing two separate Graph Builder graphs and copying the frame contents from one and pasting it into the other.

Re: Data visualisation info Graph with two curves displaying point without changing data table

txnelson — Thu, 11 Oct 2018 02:26:20 GMT

In my example, I just create a Ttransform Variable within Graph Builder, which only has the Female values. The formula I use in the Transform Variable is:

If(:Sex == "F", :height, .)

I used the Big Class sample data table for my example. Here is the Script the Graph Builder generated based upon the setting I interactively set

Graph Builder(
	Variables(
		X( :weight ),
		Y( :height ),
		Y(
			Transform Column(
				"Female Heights",
				Formula( If( :sex == "F", :height, . ) )
			),
			Position( 1 )
		)
	),
	Elements(
		Points( X, Y( 1 ), Y( 2 ), Legend( 5 ) ),
		Line Of Fit( X, Y( 1 ), Y( 2 ), Legend( 7 ), Degree( "Quadratic" ) )
	),
	SendToReport( Dispatch( {}, "Y title", TextEditBox, {Set Text( "Height" )} ) )
)

Re: Data visualisation info Graph with two curves displaying point without changing data table

ivomdb — Thu, 11 Oct 2018 11:30:23 GMT

@txnelson

The issue I have is that I can't show the two curves differently. Using your example, both curves are showing as points and fit line. Is there a way of having the Female heights as a smoother line and the Height data as points for instance ? Because I can't do that under graph Builder.

Also, if I would like to show only the people that have a weight equal to 105, 84 and 112 regardless of sex I can't do that. Even If I create another column how can I show only the heights of people that have these weights?

In my case, I have a measurement recorded through time which I would like to show only the values for specific times lets say day 1, day 2 and day 3 etc, but I do not want to see the values of the measurement between days. So if I have data from a measurmeent recorded continuously every hour during 5 days, I would like only to see the recorded value at day 1, day 2, day 3, day 4 and day 5. So I would only have 5 points in the graph instead of 120 points.

Re: Data visualisation info Graph with two curves displaying point without changing data table

ivomdb — Thu, 11 Oct 2018 11:54:32 GMT

Re: Data visualisation info Graph with two curves displaying point without changing data table

ivomdb — Thu, 11 Oct 2018 12:01:10 GMT

This seems to work. I just thought there would be a more stream line way of doing it so I can get a script running on the back and produce all the graphs I want... Thanks anyway!

Re: Data visualisation info Graph with two curves displaying point without changing data table

Phil_Kay — Fri, 12 Oct 2018 10:54:12 GMT

Hi Ivo,

You can select multiple graph elements (points, smoother, connecting line, ...). You just need to shift + click on the elements that you want.

Then in the properties area of graph builder (lower left) you can select and deselect the variables that use those elements.

So it is not difficult if you have overlaid y-variables and you want them plotted with different graph elements.

Regards,
Phil

Re: Data visualisation info Graph with two curves displaying point without changing data table

Phil_Kay — Fri, 12 Oct 2018 10:56:24 GMT

Look for "Element Types and Options" in the JMP help documentation for Graph Builder.

Re: Data visualisation info Graph with two curves displaying point without changing data table

XanGregg — Sun, 14 Oct 2018 23:11:01 GMT

You can narrow which variables apply to which element by opening the "Variables" section under each elements properties panel group.

When open, you see a list of all the variables in the graph, and you can choose which ones apply for that element.

For your example, you may want to create a second X variable with just the points you want.

You can add multiple Line elements by graph > right-click > Add > Line or by dragging from the Line element icon into the graph. Then you can choose turn off some variables for each line to get the effect you want.

Re: Data visualisation info Graph with two curves displaying point without changing data table

ivomdb — Tue, 16 Oct 2018 14:52:52 GMT

I have realised that I could use similar approach and create a new column showing the Y for specific X using the Match function. Thanks.