Forum Discussion
Custom Bin for Column Chart
Just needed to change the value field to be a count. Solved!
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
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.
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.