topic Re: get values linked to axis labels in Discussions

get values linked to axis labels

HannesJ — Tue, 07 May 2024 15:50:58 GMT

Hello, I have a control chart that has 3 different label rows on the X-axis. Is there a way in JSL to get the values that are associated with these labels? For example, for label row 2 I want to get the value that is corresponding with label "30", which is "5.5" in this case.

thanks!

Re: get values linked to axis labels

jthi — Tue, 07 May 2024 16:21:27 GMT

I think the situation is still the same as here -> there is no easy way of getting those. You can calculate them but depending on what you are doing it can be very easy/complicated.

Re: get values linked to axis labels

HannesJ — Tue, 07 May 2024 18:44:21 GMT

That's unfortunate. The reason that I would like to get these values through JSL is because I want to add some code to the script that generates the control chart to have automatic updates of the X-axis. The control chart is a dynamic chart that gets populated with data on a daily basis and I would like the X-axis to automatically move forward as more data is being added, whilst keeping the same X-axis width (hence it would always show the most recent data for let's say the past 20 weeks). Are there any ideas how to do this? For now I only could come up with these values that I could use as variables.

Re: get values linked to axis labels

jthi — Tue, 07 May 2024 19:09:09 GMT

Which platform are you using for control charts (Control Chart Builder or Graph Builder)? Do you have more than one row of labels in your x-axis (in your screenshot you seem to have three label rows) and if you do, do all of them always have the same amount of labels?

Re: get values linked to axis labels

txnelson — Tue, 07 May 2024 19:22:21 GMT

Here is one method that should work.

Assumptions

You want to use all of the data to calculation the Control Limits
You want to display only the last n number of data points on the control chart and that the rows who's values are to be displayed can be selected in the data table

The steps would be

Run the Control Chart on all data.
1. Run it in invisible mode
2. Save the control limits to a new data table
Close the report window
Subset the original data table leaving only the data you want to be displayed
Read into JMP memory variables, the control limits saved in the previous step
Run the Control Chart on the Subsetted data
1. Use the Add Limits message to the control chart code to set the control chart limits

The displayed control chart will have an axis limited to the data found in the subsetted table.

Re: get values linked to axis labels

HannesJ — Tue, 14 May 2024 08:08:27 GMT

I am using the control chart builder platform and indeed have 3 label rows on the x-axis, but they don't have the same amount of labels.

Re: get values linked to axis labels

HannesJ — Tue, 14 May 2024 08:10:33 GMT

Hi Jim, great tip.

I was able to set up a script that achieves what I wanted using a subset of the data as you suggested.

Thanks a lot!

Hannes