I attached a sample workbook, which contains two worksheets.
Last Day Ran Percentile
Calculate the rank_percentile for all dates and filter with LAST()
Last day is marked as red.
Sample_v2018.1.twbx 14.8 KB
Thanks. I can't open this because of version problem. Could you tell me what's the LOD expression for this? Thanks！