I was just curious, as it comes up a lot, but is there an easier way to create a balance range than the script below? We also use an input box version where to enter the range you want, but then if we end up with too many calculated dimensions in a report using that input box, it really affects the performance of the report. So, is there an easier function to take something like a balance and just say break it out in $100 increments as a new field? Look forward to hearing how others tackle this.
IF(ACCT_BALANCE<=200,'<200', IF(ACCT_BALANCE>=200 AND ACCT_BALANCE<=400,'200-400', IF(ACCT_BALANCE>400 AND ACCT_BALANCE<=600,'400-600', IF(ACCT_BALANCE>600 AND ACCT_BALANCE<=800,'600-800', IF(ACCT_BALANCE>800 AND ACCT_BALANCE<=1000,'800-1000', IF(ACCT_BALANCE>1000 AND ACCT_BALANCE<=1500,'1000-1500', IF(ACCT_BALANCE>1500,'1500+' ))))))) AS BalanceRange
@Saravanan_Desingh So I like this and it seems to be a great solution to my previous method. The only problem is that the set cap of 5000+ that I put in shows up for each record instead of grouping them when I add it as a selectable field. (See image).
All other records fall under the numeric ranges, but each one set as 5000+ shows individually.
I had to remove the 5000+ section because it broke them all out individually instead of into a 5000+ bucket. But, doing it this way yout WILL get the entire breakout by whichever breakout you set... for example increments of 100