How to prepare a line chart for K means clustering

[Pedro Bastos 2]

Hello,

I am trying to do a cluster analysis I have data from multiple variables and I want to group them into cluster. I have been unable to format the data accordingly in order to do a line chart that is suitable to work with K means clustering.

I don't know what am doing wrong.

Kind regards.

[Manoj Singh]

Can you please share more description along with the Sample analysis file with embedded data so that we can help you accordingly

[Anders Gavare]

If you are not really interested in line chart clustering specifically, but clustering in general, you may want to look at:

 

The Sample analysis file called "Advanced Analytics" that comes with the Analyst client. Look at the page called "Easy segmentation of data", and in particular look at the custom expression that is used on the coloring axes in those plots. It uses the TERR function kmeans to calculate the color of markers. You are then not bound to line charts specifically.

For other types of clustering (besides kmeans), you may want to create a Heat map with dendrograms. You then have several options for the clustering method, distance measures, normalization, and null value replacements. See for examplehttps://www.tibco.com/blog/2017/09/18/spotfire-tips-tricks-hierarchical-cluster-analysis/for a quick introduction.