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 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.
