aggregate pie chart

  • 1
  • Question
  • Updated 1 month ago
  • In Progress
Hello all,
I am converting a rather large file (over 3000 records) from a basic model to a aggregate model. I have a pie chart to show a breakdown by type for the basic model, but for some reason I can not aggregate the pie chart well. What I have done is aggregate the type by count (since it is a string) then what I would like to do is group by the same field.  If anyone has any ideas on how exactly to do this it would be greatly appreciated 
Photo of Jack

Jack

  • 120 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,050 Points 10k badge 2x thumb
Hi Jack,

You might be able to set up a 'count' on the ID field of the record, then group by type. That would be useful if you were trying to count the total number of records, and then group them by type. 
Photo of Jack

Jack

  • 120 Points 100 badge 2x thumb
This did not work. There is an error that states the id does not support the count aggregate. Any other possible solutions? 
Photo of Josh Merritt

Josh Merritt

  • 918 Points 500 badge 2x thumb
I've never run into a count issue using Salesforce Id's, but it's often perplexed me that I couldn't count booleans. My work around is to simply use a number field that's either 0 or 1 accordingly. If you have a "unique" records fields for the salesforce trick 'power of one', that'd be an ideal candidate to sum to get the counts you're after.
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,050 Points 10k badge 2x thumb
Hi Jack, can you share which Salesforce object and fields you're using, and what the exact error message is?
Photo of Mark DeSimone

Mark DeSimone, Official Rep

  • 11,050 Points 10k badge 2x thumb
Hi Jack. Are you still having trouble with this issue? If so, let us know what your status/issues are.