
1. Re: Bucketing and Counting Customers Within Buckets
Dan Huff Apr 3, 2013 1:54 PM (in response to Bryce Cazier)Bryce
I have attached an example that may help. Am I correct in assuming that your Bin calculation is an Aggregate calculation? By this, I mean does that Net Revenue Increase Buckets calculation show up in the measures list in your workbook?
If it does, the attached example may well be the solution you will need. There are a handful of things that I have done in the workbook. I will outline them here:
 Right click the bin calculation on the Rows shelf and uncheck Ignore in Table Calculations
 Create something like the Count of Customer calculation
 Add customer to the level of detail
 Add this calculation to columns, right click the calculation, hover over compute using, and click customer
 Create the index()=1 calculation, add this to level of detail, right click the calculation, hover over compute using, and click customer
 Finally drag this index()=1 calculation to the filters shelf
This results in giving us an aggregate bin and correct numbers for the customers within each.
Hope this helps,
Dan

Counts by AGG Bins.twbx.zip 384.1 KB

2. Re: Bucketing and Counting Customers Within Buckets
Bryce Cazier Apr 4, 2013 5:07 AM (in response to Dan Huff)Dan,
Thank you very much for the quick response. The solution worked. I do have one question though, the bars are now showing as if there is a small piece of the bar for each customer. Is there a way to see a solid bar as you have?
Thanks again,
Bryce Cazier

3. Re: Bucketing and Counting Customers Within Buckets
Dan Huff Apr 9, 2013 8:27 AM (in response to Bryce Cazier)Sorry i let this slip under my radar Bryce. My solution should have handled this. Would you mind posting a screenshot of what you see? A screenshot like the one I have attached would be just fine.
Thanks,
Dan
What I need.png 25.8 KB


4. Re: Bucketing and Counting Customers Within Buckets
. Nimesh82 Feb 4, 2014 12:23 AM (in response to Dan Huff)Dan,
This solution worked perfectly for us, Thanks!. I have a follow up question, is there a way to show percentage along with numbers, so the bin would be broken by numbers and percentage?
Thanks,
Nimesh

5. Re: Bucketing and Counting Customers Within Buckets
Gopi Chand Mar 10, 2018 10:47 AM (in response to Dan Huff)