What is the process of verifying if a value falls within a certain range of values in Spotfire?

edit

To verify if a value falls within a certain range of values in Spotfire, you can use the AND function in a calculated column or a custom expression.

The AND function takes two or more logical expressions as arguments and returns TRUE if all the expressions are TRUE, and FALSE if any of the expressions are FALSE.

Here's an example of how you can use the AND function to verify if a value falls within a certain range of values:

1. Create a new calculated column or a custom expression in your Spotfire table.

2. Use the AND function to check if the value falls within the range of values:

• For a calculated column, enter a formula like this: AND([Value] >= 10, [Value] <= 20)

• For a custom expression, enter an expression like this: IF(AND(10 <= [Value], [Value] <= 20), "Yes", "No")

1. The formula or expression will return TRUE or "Yes" if the value falls within the range of values (10 to 20 in this example), and FALSE or "No" if it does not.

You can then use this calculated column or custom expression to filter, group, or visualize your data based on the range of values.