cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Setting up a pre-selection of categories and variables for Dashboard users

EB101
Level II

I need my dashboard to be fully flexible and allow users to pre-select:

 a- The reference category from the variable "Group"

 b - The variables on which to run the dashboard on.

 

Then, the dashboard to use these such the code knows that:

Ref = "name of reference group selected"
cols = { list of columns selected}

 

Is there a way to have a dialogue window populate with the categories of a variable and the names of the columns, that users then pick from, click OK and then the dashboard runs as normal?

 

Thanks

5 REPLIES 5
ih
Super User (Alumni) ih
Super User (Alumni)


Re: Setting up a pre-selection of categories and variables for Dashboard users

Have a look at the column dialog or filter col selector functions to let the user pick a column (the following examples are from the Scripting Index):

 

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
Column Dialog(
	ex y = ColList( "Y", Min Col( 1 ), Max Col( 2 ), Data Type( "Numeric" ) ),
	ex x = ColList( "X", Max Col( 1 ), Modeling Type( {"Continuous", "Multiple Response"} ) ),
	Line Up( 2, Text Box( "Alpha" ), ex = EditNumber( .05 ), Text Box( "Beta" ), ey = EditText( "xyz" ) ),
	HList( cb = Check Box( "check", 1 ) ),
	HList( combo = Combo Box( "option1", "option2" ) ),
	HList( rb = RadioButtons( "a", "b" ) )
);
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Col List Box Example", fontobj = lb = Filter Col Selector( width( 250 ) ) );

A radio box might help select levels of a column:

 

Names Default To Here( 1 );
dt = Open("$Sample_data/Big Class.jmp");
New Window( "Example", rb = Radio Box( associative array( dt:sex << get values ) << get keys ) );

 

 

 

 

EB101
Level II


Re: Setting up a pre-selection of categories and variables for Dashboard users

That is great, i've managed to set it up for my data, but two things I'm not too sure about now.

- is rb the selected item? can I then use it in the code:

 

oneway1 = dt << Oneway( Y( cols[1] ), X( :Group ), With Control( 1, {"rb"} ) )

- Can I set a button to say ACCEPT and then it closes the window?

ih
Super User (Alumni) ih
Super User (Alumni)


Re: Setting up a pre-selection of categories and variables for Dashboard users

You could use rb << Get or rb << Get Selected.  Here is how I found that in the scripting index (available under the help menu):

 

ih_0-1632485827952.png

 

As to closing the window, a web search for 'jmp new window get user input' took me to the link below which has an example to get you started:

 

Re: How do I display a text box asking for input from the user. 

 

EB101
Level II


Re: Setting up a pre-selection of categories and variables for Dashboard users

Thank you for the pointers. It is all looking very promising, I have two final questions on this, I did a search on the community and in the scripting guide, but I couldn't see answers so apologise for the basicness.

 

- Is there a way for users to select multiple options from the radio box?

- My list of columns is very long, and it would be helpful to have the list over 3 columns - is it possible to format the radiobox to display the options over multiple columns?

 

Thanks!

ih
Super User (Alumni) ih
Super User (Alumni)


Re: Setting up a pre-selection of categories and variables for Dashboard users

You could use a check box instead which does allow multiple selections. As to showing that in multiple columns I don't know of an out-of-box method but you could subset the larger list and display a third of the list in separate check boxes, and then have your script look through the results of each.

 

Another option, if you want the user to select a column from a list of columns, check out the Column Dialog object. That might give you a quick way to create your whole launch window.