I don't really understand what's not working for you in creating bins. Are you getting an error message in your calculated field? Are the results not looking the way you want, or are they not calculating correctly? How are you doing it manually now that's not working for you? If you can post a sample worksheet and/or some screenshots, that would help a lot.
To add a little help: If it were me - not having your data set on hand, but guessing - I would use a version of your second link, a calculated field for bins:
And if the bins needed to change now and then, I would set up two parameters, to set the bin max/mins. In your example, (0-0.1%, 0.1%-0.5%,>0.5%), I'd have one numeric parameter for the 0.1% value, the other for the 0.5% value, and go from there. Example:
IF [CTR]<[Parameter 1] THEN "Bin 1"
ELSEIF [Parameter 1]<=[CTR] AND [Parameter 2]>=[CTR] then "Bin 2"
ELSE "Bin 3"
I'll look for more info and try to go from there!
I think what Etay is saying is that we cannot create bins of off calculated fields. I am having the same issue and tried the same resources, yet to no avail.
I had to create a calculated field to get "Score" (which consists of underlying data calcs), which doesnt give me the automatic "Create Bin" option b/c it's a calculated field. When I try to calculate a Bin off of the calculated field, it still doess't work.
To be specific:
My"Score" Calc is: ifnull(avg([AvgComp]),0)+ ifnull(avg([HolisticGrade]),0)+ avg([Scaled Recommend Instr])
Then I tried to Calculate a bin off of that Score calc:
if [Score] <= .10 then ".10"
elseif [Score] <=.2 then '.2'
This usually works for Measures to create bins, but not Calculated fields. Does anyone have a suggestion,please?
Thanks in advance,
I know it is a bit late, but I was looking at similar issue and found a solution.
Have a look at:
Hope it helps.
HA! Yep just a wee bit.
But thanks for sharing.