Custom Expressions not working on filtered data

Hi,

Using Spotfire 7.9.2 I created a Custom expression for ranking counts and grouping all but the top 10 into an "Other" category. 

<If(DenseRank(Count([SAMPLE_NUMBER]) over ([ANALYSIS]),"desc")<=10,[ANALYSIS],"Other") as [Analysis]>

I want the groups to be calculated on filtered data.  

Thanks a lot,

John

Update.  I found what I was looking for under Properties/Colors/Settings/Current Filtering Only.  Also works on most other axes.

Thanks,

John

 

 

 

 

(1) Answer

Login