Spotfire Ideas Portal
Binning is a very useful feature for dashboarding and also for ad hoc analysis and data discovery to add new categorization criteria.
But currently Insert Binned Column dialog is not available for in-database connections.
Instead users could use Create Calculated Column, but this is cumbersome and not suitable for non-IT users because of the need to create a corresponding formula.
Spotfire would need to switch Insert Binned Column dialog from using binning functions like BinBySpecificLimits, BinByEvenIntervals etc. to Case When statements, which can be translated to SQL like this is already done for
0
Future Consideration
When using external data connection to SAP HANA the support for binning function with BinByEvenIntervals was added. It can be used as an expression and also the "Auto-bin column" checkbox is show. But still the create Binned Column dialog is not enabled. Also BinBySpecificLimits is missing even though it is straight forward SQL.
Also using binning on a value axis to create quickly a histogram is not possible. Very cumbersome to create a histogram to analyze data distribution therefor which is a very common use case.