cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
jan_kreuzmann
jan_kreuzmann
Level III

Dashboard filter dynamic X-axis but fixed limits of control charts

Created: Apr 29, 2021 10:48 AM  |  Last Modified: Jun 11, 2023 4:13 AM (2358 views)

Hey there,

I want to create a dashboard with filter where control charts are displayed. The dynamic X-axis after the filter works, but the limits of the control charts should be calculated from all available batches in the table, not only from the selected batches. So I want to see if a batch showes any abnormalities in one of the parameters with respect to the previous batches.

I generated a little Dashboard in which I can choose my Lot number I like to compare to the rest. I was thinking of adding more and more of Lot and have a look on some special parameters with this dashboard.

I rearranged the filter and control chart windows but that did not do the job so maybe someone here might know how to fix it.

Thanks in advance!

Jan

Dashboardtest.jmp
0 Kudos
11 REPLIES 11
tonya_mauldin
Staff tonya_mauldin
Staff
Solution

Re: Dashboard filter dynamic X-axis but fixed limits of control charts

Apr 30, 2021 10:30 AM (2271 views)  |  Posted in reply to message from jan_kreuzmann 04-30-2021

Turning on include is going to cause your control limits to change as you discovered.  Include in the data filter is similar to the Exclude row feature in a data table.  When observations are excluded in the data table, those observations are not used to calculate control limits.  Therefore, as you choose options in the local data filter with include turned on, your control limits will change.  You can either set your control limits via a column property for each response or you can use the Set Control Limits Command via JSL or a right-click in each of the CCB graphs and set the limits to be what you desire.  By using column properties or the set control limits command, your limits will not change as you select items in the local data filter.

jan_kreuzmann
jan_kreuzmann
Level III

Re: Dashboard filter dynamic X-axis but fixed limits of control charts

May 3, 2021 05:15 AM (583 views)  |  Posted in reply to message from tonya_mauldin 04-30-2021

Thanks for your help! The information about the column property possibilities was what was missing for me.

Now it works for me.

I use the following work flow right now:

  1. Import of data
  2. Run of all control charts and saving the limits to the columns
  3. Run of dashboard
  4. After this I can chose the observations I like to compare and my X-axis in all control chart only show these observation.

I will try to run all of it untill point 3 using scripting, but that will come later.

0 Kudos