Is there really not an easy and elegant way to do basic histogram with custom bins? I remember this functionality being present in excel 20 years ago.. I would really appreciate help - I want Qlik Sense to work for our company, but if Histograms are not available I will not be able to "sell" this to my management.
A fairly simple and flexible way to utilize bis of differing widths is to assign the Bin in script using IntervalMatch. Here's an example.
round(rand() * 2000) as Value
LOAD * INLINE [
Bin, Start, Stop
bin1, 0, 1
bin7, 1001, 9999999999
LOAD Start, Stop resident Bins;
DROP FIELDS Start, Stop;