Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to count total number of data point belong to a cluster. In table below, column 4 is using KMeanCluster2D to cluster ID into 5 cluster. I want to count the number of ID belong to a cluster in Column 5.
Note: it should be a chart function.
I am trying to apply Silhouette Analysis to pick the K Value (although in my example, K value is already chosen).
may be this ?
=count(aggr(KMeans2D(vDistClusters,only(latitude),only(longitude)), nodistinct id))
=count( nodistinct aggr(KMeans2D(vDistClusters,only(latitude),only(longitude)), total id))
@brunobertels unfortunately it doesn't work.