Remove empty subplots in Group X graph

[#1]

Good day,

I have a certain data of Y by X for a range of months and years. I would like to visualize this data without overlays, i.e. where each plot is located next to each other. (The reason is that real Y by X data may already contain several datasets overlayed).

Typically, I would add Year and Month as Group X variables. The problem is this creates a lot of blank "subplots" if there are no entries for each permutation of Group X variables. I would like to remove these empty "subplots".

 Other notes:

• I would like to use both Year and Month as Group X variables, and prefer not to create an additional variable "Year-Month".
• X and Y are typically continuous variables, Month and Year are typically nominal variables.

I'm using JMP 18.1.1.

Attached is the JMP table with a dummy data used for this example.

[#2]

Creating combined column (like you suggested) is usually the easiest way to solve this fairly common issue you can (and will) come across with Graph Builder. There are some workarounds but they can be risky and will take some effort.

If I remember correctly, there are quite a few wishes about improving this in JMP Wish list.

[#3]

A related wish, but not exactly the same:
 X group: restrict the values on the axis to the respective group 

[#4]

For date values on the X axis, one can activate Label Row Nesting:

here is a wish to implement a similar functionality for Group X/Y:
Label Row Nesting for Group X 

[#5]

你好，

我测试过你的问题了。

如果你只需要显示数据点而不需要均值连线，那么采用另外 hogi 的建议，使用 X 轴的变量嵌套即可；但如果你需要均值连线的话，嵌套似乎无法将均值连线以月份做分隔。

不过，如果你只需要一张漂亮的图形的话，有一种变通的办法，使用测量系统分析（MSA），然后做一些简单的设置即可，希望能对你有所帮助。

方法和效果如下（注意：由于数据不存在重复测量，所以会提示无法计算标准差的错误提示，直接忽略它）：

  

最后，很久没有来社区了，它的语言翻译功能似乎更好用了。我来自中国，我英语不太好，以前我回帖交流还需要使用第三方翻译，现在似乎不需要借助第三方翻译就可以直接完成我们的跨语种的交流了。这是一个非常不错的改进。

[#6]

Thank you for suggestions!

Indeed, if X variable is nominal, I can nest both group variables under X axis, which however connects points across the groups:

Using MSA platform to make a plot is an interesting idea, thanks!