I have a list of Orders. I need to calculate the most recent, the second most recent and the oldest Order for each Account.
In Einstein Analytics I use the field "Compute Relative":
I created the following fields:
When I let the flow calculate, it throws me an error: "Something went wrong while executing the computeRelative Order-Account node: Transform dim/mea not found in Edgemart: Last_Order"
Only the "First Order" field runs through without an error, but I only get null values and no "x" for the first Orders...