Visualizing Control Charts for multiple instrument and parameters in one platform/interface (user-friendly)

[#1]

Hello,

I'd like to get your input on something I want to implement in my team, and to a greater extent, in the company I work for.

Context:

We are running a number of processes in multiple instruments. For each of these, we collect a lot of results (process performances) that we measure.

We use control charts to visualize if a process is in control in an instrument but this can lead to to tens of control charts per process per instrument.

Instruments are grouped in cluster and I have datatables for each cluster. These datatables are grouped in one JMP project.

Problem statement:

I would like to create an interface where you can select the instrument, the process and the parameters/performances you want to visualize. The interface should be pretty user-friendly (for example using buttons and drop-down list or selecting items). Then clicking on a "Display control charts" button, would either have for effect to open a new window or display in the same window the selected control charts. There will also be an "update" button that would update the JMP datable, which is at the moment, linked to an Sharepoint-Excel table, such that you would always have the latest version of the data when you visualize the control charts. (I have everything here, I just need to implement the update button, should be straightforward).

I've used AI to sort of generate what I would ideally like to have:

Routes for a solution

I initially thought of using a JMP journal, combined with JMP dashboard but before spending time in this direction I would like to have some feedback on the feasibility of that little project I have and on the best options. Should it be a JMP journal, a JMP dashboard or an application (which means I would need to start scripting in JSL) ? Is that even feasible with JMP at the moment ?

Thank you in advance for your help and any idea is welcome!

[#2]

You might be able to do this with control chart builder + local data filter and then workflow/update table script to update the data. If you want the UI look exactly like that, I would go with more customized JSL solution. 

[#3]

bonjour,

je fais des dashboards avec le même modèle:

filtre de données locales (sélection année, mois, produit + autres variables), des tab page boxes avec graphique + tableau récapitulatif pour avoir quelques statistiques (nombre de résultats, moyenne, écart-type,..). quand j'ajoute les cartes de contrôle, j'utilise l(IMR avec de plus en plus souvent le sélecteur de colonnes. Il faut bien paramétrer les variables pour que l'axe Y s'adapte à chaque variable dans la carte de contrôle.

cordialement

[#4]

Process Screening provides an interactive summary table and some graphical methods to see all your processes in a dashboard-like view. Instantly generate the control chart(s) for process(es) of interest by clicking on them in the table, then drill-down further as needed. 

See the Semiconductor Capability.jmp sample dataset as a reference. Run the built-in Process Screening analysis, using the Red Triangle Menu to enable Show Charts as Selected. Next, try using a Local Data Filter to filter by, say, SITE, in the example dataset. Would this functionality allow your users to filter to their cluster/chamber/process of interest? 

My recommendation for one-click update from your SharePoint data source: OneDrive and SharePoint Data Connector.