I believe you would want to create a Boolean which checked if a date met the threshold. If you provide us with a packaged workbook, we could take a closer look and try to give a specific answer.
If you've already found a solution, please share for other users to find and use!
I still haven't got any solution in my mind.
Please see the attachment for your reference.
I would like to calculate the percentage of no. of days to the whole period which the average hard bounce rate is above the benchmark 0.5%.
Benchmark question.twbx 683.9 KB