topic Re: Is it possible to achieve this type of plotting using JSL? in Discussions

Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 10:44:02 GMT

Plotting in a specified column: Plotting data from multiple columns in the same row as a graphic within this column.

It seems the effect of the new column manager is not like this.

Thanks!

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 11:30:16 GMT

You can create the plot in graph builder, save the graph(s) as data table and join to your table

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 12:03:07 GMT

I wanted to have a quick way, easy like excel.

Of course, that's not the figure I showed above.It's just a schematic.

Thanks!

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 12:14:43 GMT

I have no idea what you mean by quick in this case

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 12:22:45 GMT

JMP does have Hist Seg which could be used in formula to build something like this

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 12:57:05 GMT

Thank jthi !

How can it be implemented with JSL?

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 12:59:43 GMT

You have great example how to create Hist Seg with JSL. Combine it with data table subscripting to get the values and finalize with << Get Picture on the Hist Seg (or some other method of turning it into picture)

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 13:12:41 GMT

I can't find this Hist Seg formula
How to use JSL can only be done in a loop step by step.
It's convenient if you can do it in a formula.

Thanks Experts!

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 13:32:25 GMT

Looking at the Hist Seg application in this help is completely different from excel's graph, I need to use a row of multiple columns of data to create a graph

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 14:14:11 GMT

And you can for example use data table subscripting to access values row by row.

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 14:30:22 GMT

That data you have in excel doesn't look same as you did provide us with so it is impossible to know what you wish to have

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 15:08:59 GMT

Do not have all columns of data mapping, only 188-202 columns of data mapping

Thank jthi !

dt = Current Data Table();
q=188;p=202;na="Row 3 Columns "||char(q)||"-"||char(p)||" Bar Chart";
row_data = dt[3, 188::202];
n_points = N Col(row_data);
x_values = Index(1, n_points);
y_max_data = Max(row_data);
y_max_scale = y_max_data * 1.1; 
if(y_max_scale == 0, y_max_scale = 10); 
New Window(na ,
	g = Graph Box(
		Frame Size( 400, 200 ),
		X Scale( 0.5, 12.5 ),   
		Y Scale( 0, y_max_scale ),     
		Pen Size( 1 ),         
		Fill Color( "Light Purple" ), 
		For( i = 1, i <= n_points, i++,
			Rect(             
				x_values[i] - 0.4, row_data[i], 
				x_values[i] + 0.4, 0           
			)
		)
	)
);
frame = g[FrameBox(1)];
frame << Grid Line Order( 1 );
frame << Add Graphics Script(
	Text( Center Justified, {6, y_max_scale * 0.95}, na )
);

Mine is ugly

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Tue, 25 Feb 2025 15:34:34 GMT

And I assume you now have your solution?

Re: Is it possible to achieve this type of plotting using JSL?

lala — Tue, 25 Feb 2025 23:38:32 GMT

I need your help with answers.

Thank jthi !

I want to learn how to do that with a formula.

Re: Is it possible to achieve this type of plotting using JSL?

jthi — Wed, 26 Feb 2025 07:23:44 GMT

I don't suggest doing this type of things in formulas as they don't get properly re-evaluated. Formula:

start_idx = 188;
end_idx = 202;

ncol = end_idx - start_idx + 1;
vals = Current Data Table()[Row(), start_idx::end_idx]`;
vals[Loc(vals, .)] = 0;

g = Graph Box(
	Frame Size(300, 120),
	X Scale(-0.5, ncol + 0.5),
	Y Scale(0, Max(vals) + Max(vals) * 0.05),
	Fill Color("Dark Blue"),
	For(i = 1, i <= ncol, i++,
		Rect(i - 1, vals[i], i, 0, 1)
	);
);
g[FrameBox(1)] << get picture;

I would rather have a table script which would then re-create the images when that table script is run

Re: Is it possible to achieve this type of plotting using JSL?

lala — Wed, 26 Feb 2025 08:42:25 GMT

Thank jthi !

I just need a quick map. That should do it

Re: Is it possible to achieve this type of plotting using JSL?

lala — Wed, 26 Feb 2025 09:49:47 GMT

This form of mapping allows you to make a vertical inversion of the graph (not a simple rotation of 180 degrees).

Of course, it can be done in other ways.I've tried taking negative values and using histograms to do the same thing.But it would be faster if we could just erect it.

Thanks Experts!

Re: Is it possible to achieve this type of plotting using JSL?

lala — Wed, 26 Feb 2025 09:59:06 GMT

 Rect(i - 1, max_val, i, max_val - vals[i], 1)