topic Re: How can I manually ordering hierarchical clustering? in Discussions

How can I manually ordering hierarchical clustering?

doraemengs — Fri, 21 Jun 2024 14:04:11 GMT

Hi,

I have an example data on JMP as attached. I want to create the heat map in hierarchical clustering. However, I want to order it manually. I have tried to use "save cluster" and then generate the hierarchical clustering with order by save cluster that I modified sequentially order as I want. As you see in picture 2 clusters 1 and 2 do not next to each other. How can I order it manually on JMP?

Figure 1 Hierarchical clustering using "Ward"

Figure 2 Hierarchical clustering with order by modified "save cluster"

Re: How can I manually ordering hierarchical clustering?

MathStatChem — Fri, 21 Jun 2024 18:25:56 GMT

After to save the cluster IDs, save the script, sort the table by Cluster and then rerun the Hierarchical Clustering script again.

The horizontal rows in the dendrogram correspond to the row number in the table.

Re: How can I manually ordering hierarchical clustering?

doraemengs — Wed, 07 Aug 2024 20:46:26 GMT

Thank you so much, but it does not work. Any other ideas?

Re: How can I manually ordering hierarchical clustering?

PatrickGiuliano — Tue, 04 Feb 2025 22:17:31 GMT

@doraemengs, I checked @MathStatChem 's solution here, and this appears to be working now in JMP 18.1.1, regardless of whether the clusters are ordered chronologically in the table:

(view in My Videos)