RFM scores - milliseconds
![user1502](https://us.v-cdn.net/6038102/uploads/defaultavatar/nLP0QHCLH24WL.jpg)
user1502
New Altair Community Member
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
![Image: https://us.v-cdn.net/6030995/uploads/editor/u9/oj0g8tanx55f.png](https://us.v-cdn.net/6030995/uploads/editor/u9/oj0g8tanx55f.png)
![Image: https://us.v-cdn.net/6030995/uploads/editor/rd/n3k39d0et8o3.png](https://us.v-cdn.net/6030995/uploads/editor/rd/n3k39d0et8o3.png)
![Image: https://us.v-cdn.net/6030995/uploads/editor/wh/pilh8icbay6o.png](https://us.v-cdn.net/6030995/uploads/editor/wh/pilh8icbay6o.png)
![](src)
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
![Image: https://us.v-cdn.net/6030995/uploads/editor/u9/oj0g8tanx55f.png](https://us.v-cdn.net/6030995/uploads/editor/u9/oj0g8tanx55f.png)
![Image: https://us.v-cdn.net/6030995/uploads/editor/rd/n3k39d0et8o3.png](https://us.v-cdn.net/6030995/uploads/editor/rd/n3k39d0et8o3.png)
![Image: https://us.v-cdn.net/6030995/uploads/editor/wh/pilh8icbay6o.png](https://us.v-cdn.net/6030995/uploads/editor/wh/pilh8icbay6o.png)
Tagged:
0