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
Question
aggregate pie chart
+2Translate
This topic has been closed for comments
+9- Nintex Employee
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.
Translate
+2This did not work. There is an error that states the id does not support the count aggregate. Any other possible solutions?
Translate
+9- Nintex Employee
Hi Jack, can you share which Salesforce object and fields you’re using, and what the exact error message is?
Translate
+4I’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.
Translate
+9- Nintex Employee
Hi Jack. Are you still having trouble with this issue? If so, let us know what your status/issues are.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.