Creating custom buckets in Cross Table
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.