Custom Expressions not working on filtered data
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,
Update. I found what I was looking for under Properties/Colors/Settings/Current Filtering Only. Also works on most other axes.