Creating custom buckets in Cross Table

Dear Team,

Please refer to the attached screen shot.

This i have sourced from excel and need to implement the same in Spotfire.

On horizontal axis i need some buckets to be created such as shown in the attached. Similarly in the Vertical axis i need another set of buckets to be created based on outstanding amounts & in the cell values i will have the customer count.

What spotfire is doing is that it is creating auto bins which is not as per requirement. if we can build a statement like cse etc then my purpose would be solved. for example:

case when ([OS_Days]) between '0-100' then 'Category A' so on and so forth however i could not find between operator in Spotfire.

Request all to kindly advice on the same.

Regards, Shivi


Image icon collections1.png20.84 KB

(2) Answers