How to get count of values outside a min and max range


First time posting to the community and relatively new to Spotfire so please excuse what I believe to be a simplistic question.  I am working to create a data quality page.  One of the things we want to do is a reasonability check and get a count of values above and below a static min and max value.  I think it would look something like a summary table of values outside of range.

We would also want to flag and exclude these values in our aggregated calculations.

Any suggestions on how to approach this problem using Spotfire?

Thank you and kind regards,



(1) Answer