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