How to create dynamic grouping for the bottom or top "N" rows, in the Spotfire Analyst / Professional desktop client.

How to create dynamic grouping for the bottom or top "N" rows, in the Spotfire Analyst / Professional desktop client.

Suppose you have data having 10 rows with groups (A,B,C,D,E,F,G,H,I,J). The requirement is to show the top five bars and add the value of the remaining five bars and show as one bar called "All others". In total, see six bars should be seen.

Also Top 5 can change to Top 7 , Top 6, Top 3 etc., and the remaining ones should add up as a single Group. Currently, there is no direct way to create this grouping in the Professional/Analyst client. Use the steps shown below to achieve dynamic grouping for "N" rows in the Spotfire Analyst / Professional client.

1). Create an input field to get the input in text area .

2). Create the new calculated columns shown below.

Rank = Rank([Column1],"Desc") /* calculate rank of values on column1 /*

New Group = If([rank]<=DocumentProperty("topvalue"),[Column2],"All Others") /* Give Group new value to "All other" if rank is greater than the values provided in input field /*

Now we can use this [New Group] column in the X axis of a Bar Chart to achieve grouping. For reference is the attached file (Filename: Grouping65.dxp).