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?
Yes MFelix
every refresh overlays the data =(
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!!
Hi Anonymous ,
You don't have an updated date on your file. So you are not saving daily information, you refer that you overwritte the data so without that date this is not possible to do.
Regarding month by month I have everythi prepared.