Custom Bin for Column Chart

[Alex2]

Account Name Opportunity Name Stage

Example Account 1	Opportunity 1	Completed
Example Account 2	Opportunity 2	Lost
Example Account 3	Opportunity 3	Completed

I have a column chart with the account name in the axis and the Name Count for the Opportunities. I filtered for the records I wanted that are jobs we won. The sales team wants to see the number of customers who have ordered once and the number of customers that have ordered more than once. How do I create custom bins so I can group these up into two bars?

 

[Anonymous]

@Alex2,

What logic do you use to calculate the customers who have ordered once and customers who have ordered more than once based on the sample data you post?

What data do you want to display in the column chart(x-axis and y-axis)?

Regards,
Lydia

[Alex2]

I filtering based on opportunity stage = complete and counting the number of opportunities an account has. In the bar graph screenshot there are a bunch of 1s and then the rest have more than one opportunity. 

I'm trying to get the x-axis to be # of accounts with 1 order and # of accounts with more than one order. So two bars. The y-axis would be the number of accounts. 

[Alex2]

I created a roll-up summary field in Salesforce to get the number of orders based on my criteria for each account. Then I created a new variable. 

Range = var NumOrders = SUM(Account[Number_of_Orders__c]) return IF(NumOrders=1, "Single Order",IF(NumOrders>1, "Multiple Orders"))

I put this new measure into a new column. 

Number Orders Range = [Range]

This got me close. It is adding up the number of opportunities per account instead of the number of accounts. 

[Alex2 · Accepted solution]

Just needed to change the value field to be a count. Solved! 

[Anonymous]

@Alex2,

Glad to hear the issue is solved, you can accept your reply as answer to close this thread.

Regards,
Lydia