Forum Discussion
RFM Model - How to create a Cluster Record to visualize evolutiong throught time?
Super UserHi 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.
Yes MFelix
every refresh overlays the data =(
- MFelix
Hi Anonymous ,
Do you want to calculate this based on the update date of the information or on the order date?
I have prepared a setup based on a date dimension table and the difference to the selected value of the orders.
So basically just replace your TODAY() from your days without orders to a MAXIMUM date, and all the formulas are with measures.
I will send the explanation and file between today and tomorrow.
I want to calculate based on the update date, for example: How many of each clusters I had on December 1st, how many on December 2nd, throught every day. Also would be nice to see how many of each clusters through the months:
How many cluster when I was in 31 October, 30 November, and so on...
Did you get it?
Thank you very much!!