on 09-25-2014 2:23 PM
Hi Experts,
Can you please help me with the below scenario.
I am trying to use K-Means function to perform clustering on customer data. I have the below columns:
Attributes:
Customer ID, Home Ownership Status
Measures:
Customers Debt to Income Ratio, Annual Income
1. Is it possible to use multiple attributes given above to perform the clustering as i read that clustering can be only done using measures.
2. I need to pass the number of clusters dynamically from report to the K-Means function to perform clustering. I tried to use calculation view to get this parameter from user at runtime and pass to the input parameter table of K-Means function. But the problem is, calculation views will not allow any kind of DDL statements like create/drop/insert/delete/update etc.
3. Further i would like to understand how to use the results of the K-Means clustering delivered via two tables one having clusters, distance and other having clusters and remaining measures to build a scatter chart. How this can be achieved.
Please help.
Thanks and Regards,
M.N.Adinarayanan
Hello,
Would you share your dataset maybe I can help.
Kind regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.