cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Avshish
Level I

Plot only the filtered data from a given column on a dashboard

Hi,

I am trying to build a dash board that will plot relevant graphs.

My current issue is that it plots the entire data on one graph, highlights the filtered data and the rest is grayed out. 

I want to graph to be build only with the data of the relevant rows of the given column. 
For example, if I want to plot height as a function of age, and I have a column for "sex" which holds 'M' and 'F', so I have the filtering option
for "sex", if I choose 'F', the 'M' data will be grayed out. I want the chart to only show the 'F' data.
How do I do that? 
Thanks,

4 REPLIES 4
jthi
Super User

Re: Plot only the filtered data from a given column on a dashboard

Change the filter settings (enable Include / Show depending on your use case)

jthi_1-1712333494033.png

Edit:

This explains the different modes https://www.jmp.com/support/help/en/17.2/#page/jmp/filtering-modes.shtml#ww609720 (select isn't available for local data filter)

-Jarmo
hogi
Level XI

Re: Plot only the filtered data from a given column on a dashboard


@jthi wrote:

select isn't available for local data filter


... but there is a wish to change that:

Local Data Filter - don't disable the SELECT option (💚) 

would be quite helpful! -> plese click on the link and vote

Avshish
Level I

Re: Plot only the filtered data from a given column on a dashboard

Thanks for the reply folks,

But I'm looking for a JSL code lines to do that, not by the options I have in a graph.
To better explain myself, my code gives the user the choosing options shown below.

When the user chooses V10.7 it highlights the relevant rows under column "Layer".

I want the graph to be shown only after the user chose the layer, and show only the chosen data. 

Avshish_0-1712406816734.png

 

jthi
Super User

Re: Plot only the filtered data from a given column on a dashboard

Do it first by hand and then get the script

jthi_0-1712416323990.png

add show

jthi_1-1712416342952.png

go to red triangle menu and save script

jthi_2-1712416373058.png

Current Data Table() << Data Filter(
	Location({1104, 309}),
	Mode(Show(1)),
	Add Filter(columns(:name), Display(:name, N Items(15), Find(Set Text(""))))
)

You can also go and check Data Filter from scripting index

jthi_3-1712416432836.png

and from there you easily get to documentation by pressing Help https://www.jmp.com/support/help/en/17.2/#page/jmp/data-table-messages.shtml?os=win&source=applicati... and https://www.jmp.com/support/help/en/17.2/#page/jmp/add-a-data-filter.shtml#ww795815

 

-Jarmo