
1. Re: Creating Custom BINS
Matt Lutton Sep 27, 2013 2:41 PM (in response to Kito Patterson)1 of 1 people found this helpfulI believe you'll want to use a Calculated Field, as bins need to be the same # of values in each bin, I believeand since you want to have a category for "0", I'm not sure a Bin will allow that.
I'd just do omething like:
IF sum(Visits)=0 THEN "0"
ELSEIF sum(Visits)<6 THEN "1"
ELSEIF sum(Visits)<11 THEN "10"
etc, etc
END
Also, you'll want to move this thread into the "Forums" section to get the best possible response. By default, threads don't go there, so this happens often!

2. Re: Creating Custom BINS
Kito Patterson Sep 27, 2013 2:43 PM (in response to Matt Lutton)Thanks Matt for the quick response. I'll make sure to post all subsequent questions in the forum moving forward.

3. Re: Creating Custom BINS
Kito Patterson Sep 27, 2013 3:00 PM (in response to Matt Lutton)I tried the below, but I keep getting an error that reads "Expected END to match IF at character 0" from the formula below:
IF sum([Visits]) = 0 then "0"
ESLEIF sum([Visits]) between 1 and 6 then "5"
ESLEIF sum([Visits]) between 6 and 10 then "10"
ESLEIF sum([Visits]) between 11 and 20 then "20"
ESLEIF sum([Visits]) between 21 and 30 then "30"
ESLEIF sum([Visits]) between 31 and 40 then "40"
ESLEIF sum([Visits]) between 41 and 50 then "50"
ESLEIF sum([Visits]) between 51 and 100 then "100"
ESLEIF sum([Visits]) > 100 then ">100"
ELSE "1"
END

4. Re: Creating Custom BINS
Matt Lutton Sep 27, 2013 3:07 PM (in response to Kito Patterson)Well, first you've misspelled ELSE in several places. This would need to be:
IF sum([Visits]) = 0 then "0"
ELSEIF sum([Visits])< 6 then "5"
ELSEIF sum([Visits]) < 11 then "10"
ELSEIF sum([Visits]) < 21 then "20"
ELSEIF sum([Visits]) < 31 then "30"
ELSEIF sum([Visits]) < 41 then "40"
ELSEIF sum([Visits]) < 51 then"50"
ELSEIF sum([Visits]) < 101 then "100"
ELSEIF sum([Visits]) >= 101 then ">=101"
ELSE "1"
END
No need for the "betweens", since IFELSE statements operate in order, and are mutually exclusive, you can condense. I believe the above should work.