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

[Sean Flaherty 2]

Hello,

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 adata quality page. One of the things we want to do is a reasonabilitycheck andget a count ofvalues 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 wouldalso want to flag and exclude these valuesin our aggregated calculations.

Any suggestions on how to approach this problem using Spotfire

 

Thank you and kind regards,

Sean

[Kirsten Smith (she/her)]

If you wanted to create this value in a calculated column it might look like:

 

Sum(case when [Column]{maxvalue} then 1 else 0 end)