Spotfire Ideas Portal
SQL has a Between option. Spotfire could also benefit from a Between. We would use Between in case statements, if statements, or as standalone logic.
Today we write:
If([Data] >=1 and [Data] <= 2,true,false)
This could be updated to be:
If(Between([Data],1,2),true,false) or
also, it could look like:
case
when Between([Data],1,2) then true
else False
end
or
case
when [Data] Between 1 and 2 then true
else false
end