I'm trying to create a set analysis equivalent to this expression that I use in a pivot table's expression column:
ISSUE_DATE >= SHIPMENT_DATE
AND ISSUE_DATE < NEXT_SHIPMENT_DATE
I've already checked through community a lot but so far I could only found set analysis solutions with variables.
Since I'm not very familiar with set analysis syntax, I couldn't manage to create a working expression.
The expression above works fine but I want to write it as a set analysis expression due to better performance.
In my case ISSUE_DATE, SHIPMENT_DATE and NEXT_SHIPMENT_DATE fields are all in the same date format.
I'd appreciate any help.
Thanks in advance,