When I want to get the most recent date of the sale of a particular product, I can use BY FIRSTNONBLANK aggregator to get the value from the Transaction list of product sales data into the metric.
But, how do I select the 2nd most recent date?
For instance, I have the following sales table:
Product Qty. Date
Product A. 30. 5/12/2023
Product A. 40 3/26/2023
Product A. 15. 1/11/2023
I would like the metric, which I’m creating, select the 2nd row’s date, i.e.:
Product A. 3/26/2023
Best answer by BenoitView original