in a saved search - is it possible to get a count ...
# generalp
pen one
04/21/2021, 4:31 PMin a saved search - is it possible to get a count of a field but only of unique values?
m
MySuite
04/21/2021, 4:31 PMyes
MySuite
04/21/2021, 4:32 PMIf you group on the field with the value and then sum internal id. You'd get a count of the values.
ie
Group on amount, count internal id.
MySuite
04/21/2021, 4:32 PMI think that would work
MySuite
04/21/2021, 4:36 PMLike this:
p
pen one
04/21/2021, 4:40 PMforgot to mention that i am using that value to populate another field so grouping would not work.
pen one
04/21/2021, 4:44 PMactually - figured out another way to do this not using internal id.
👍 1
2 Views