The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
RFM scores - milliseconds
Learner I
Hello, i am trying to calculate RFM and i am stuck.
1)I saw that before the Aggregate operator (where calculate the R=max of InvoiceDate or min of InvoiceDateMillisecond, F=count of InvoiceNo, M=sum of TotalPrice) i need to calculate first the milliseconds from the InvoiceDate. Then should calculate also the difference between the milliseconds that i will create and another number again in millisecond, but i didn't understand which value will i use.
Also, can i find the Recency without the millisecond step?just to select "max InvoiceDate" in Aggregate operator?
2)How can i calculate RFM scores?
Any help?Thank you
1)I saw that before the Aggregate operator (where calculate the R=max of InvoiceDate or min of InvoiceDateMillisecond, F=count of InvoiceNo, M=sum of TotalPrice) i need to calculate first the milliseconds from the InvoiceDate. Then should calculate also the difference between the milliseconds that i will create and another number again in millisecond, but i didn't understand which value will i use.
Also, can i find the Recency without the millisecond step?just to select "max InvoiceDate" in Aggregate operator?
2)How can i calculate RFM scores?
Any help?Thank you
Tagged:
0
