Absolutely - the calc is a simple:
but then you need to set partitioning of the table calc when you use it. With the view you have here, you would use advanced, User ID on the left, Order ID on the right, sort by Order ID, minimum ascending
Awesome! Worked like a charm. Thanks Alex!!
Actually, one more question. I've added product type purchased, and it seems now the sequence is for each user - for each product type, so
UserID OrderID product type sequence what I want
123 234 book 1 1
123 256 card 1 2
123 456 card 2 3
123 983 book 2 4
124 345 book 1 1
124 764 card 1 2
125 998 card 1 1
But I don't actually care about the product type - I want the sequence to be just based on the User ID. I can't figure out how to have it ignore product type, though. Help?
1 of 1 people found this helpful
You need to go back into the advanced drop down of the table calculation index() and move product type to the right side
Alex, you did it again. And at record speed. Thanks!!