how can I dynamically filter out one min score and one max score in a dataset per quarter
basically, its a survey dataset that have a score of 0 to 10..
every quarter, we need to exclude 1 lowest and 1 highest.
we may have multiple lowest or highest, we just need to pick one of each for the quarter.
for January, we have the lowest of 5 and highest of 9. so we exlcude one 5 score and one 9 score.
for February, we have the lowest score of 2 and the highest of 9 still. so we exclude the 2 score now and bring back the 5, and just keep the 9 we excluded ofr January.
for March, the lowest is 4 and the highest is 10, so we still exclude the 2 score from February, and exlcude the 10 for march.
in summary, we excluded the lowest score for the quarter which is 2 and the highest which is 10.
I am wondering if anybody has done it in beastmode?
currently we are doing the manual exclusion of the lowest and highest, we're wondering if we can do it in beastmode