tibco - Does Spotfire provide any simple way of creating an "Other" category to group entries within a filter? -

right now, using filtering scheme looks @ data of 5 or 6 common entries in 'clinic' field. but, there handful of other possibilities might account few rows each. inconsequential include on own (i using pie charts , bar charts), these rows accounted for. reason, create "other" category groups these entries together. best way of doing this? know can create calculated column groups aside top 5 or 6 in other category, thought there might way keep working original column , achieve same result.

unfortunately not. in 6.5.x have write case statement specify not common other.

in 7.0.x can go insert binned column. add bottom can use values create bin. add values want bin , call them "other". of course if @ column created this, case statement. whole lot faster writing yourself.