cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
‘New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit – register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
lala
Level VII

How to make multi-row dashboards with JSL?

I saved the script for manually creating the dashboard to the data table and closed the data table
Reopening the table and executing the script was unsuccessful.

Thanks Experts!

dt=Open("$SAMPLE_DATA/Big Class.jmp");
p1=dt<< Graph Builder(Transform Column("row",Formula(Row())),Size(500,100),Show Control Panel(0),Show Legend(0),Show Title(0),Show Footer(0),Show X Axis(0),Show Y Axis(0),Show X Axis Title(0),Show Y Axis Title(0),Variables(X(:row),Y(:height)),Elements(Line(X,Y,Legend(5))));
p2=dt<< Graph Builder(Transform Column("row",Formula(Row())),Size(500,100),Show Control Panel(0),Show Legend(0),Show Title(0),Show Footer(0),Show X Axis(0),Show Y Axis(0),Show X Axis Title(0),Show Y Axis Title(0),Variables(X(:row),Y(:weight)),Elements(Line(X,Y,Legend(5))));

2024-07-16_15-26-07.png

25 REPLIES 25
jthi
Super User

Re: How to make multi-row dashboards with JSL?

Utilizing Stacked Data table makes creating something like this easier

jthi_0-1721637218960.png

 

-Jarmo
lala
Level VII

Re: How to make multi-row dashboards with JSL?

I tried, but couldn't figure out how to stack it.

Ask an expert for instructions.

Thank you very much!

jthi
Super User

Re: How to make multi-row dashboards with JSL?

Use Multiple series stack

jthi_0-1721650202159.png

Then create grouping column from one of the label columns, rename columns as needed, remove as needed and create a plot

-Jarmo
lala
Level VII

Re: How to make multi-row dashboards with JSL?

OK、I see

Thank jthi !

 

lala
Level VII

Re: How to make multi-row dashboards with JSL?

This creation of graph groups seems to be the default setting for many systems.
For example, the label column in this graph is the default sort

Do I want the graph to be sorted by the label of the original data table and can only be numbered in the label column of the data table?For example, the labels in the data table are sorted by C, D, A, B, E, and the graphs are also sorted by this, which can only be modified in the data table to :1C, 2D, 3A, 4B, 5E.


Setting transparency is also ineffective.

 

Thanks!

2024-07-23_11-17-20.png

jthi
Super User

Re: How to make multi-row dashboards with JSL?

Use Value Order column property for the ordering.

-Jarmo