Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to use buckets in expression value rather than numeric value.
E.g. Various values I am getting in expression are 250, 4000, 1100, 125. Now I want to show these values in buckets of <1000, 1000-3000, >3000.
Is it possible to do that?
Hi Parul,
Try:
If( Amount < 1000, '<1000',
If( Amount <= 3000, '1000 - 3000','>3000' ))) as Bucket,
This:
=If(Sum(Values) < 1000, '<1000', If(Sum(Values) <= 3000, '1000-3000', '>3000'))