Forum Discussion
RFM Model - How to create a Cluster Record to visualize evolutiong throught time?
Hi Anonymous ,
How is the granularity of the information are you getting data at a daily basis, or every refresh overlays the data?
If you have daily information for the calculation you will need to make a measure to calculate the values within each Cluster based on the daily values, if you are getting information that is ovverwritten every single day, you need to have a way of getting the daily information.
Can you share some setup and mockup data?
Hey MFelix !!
Yes of course, here it goes.
https://drive.google.com/file/d/14ZTb1Dzr3vhmg2MAmBW2WDaYr0RIYDJO/view?usp=sharing
If you look inside the file, there is going to be 3 tables (Clients, Orders and Store)
I created a calculed column inside Clients to determinate the cluster for each one of the clients based on the other calculed column days without order.
I would like to track throught time how the cluster are increasing or decreasing
Thank you very much for your reply.