Hello! Anyone have experience with using a saved s...
# general
j
Hello! Anyone have experience with using a saved search to separate and count individual values of a multiple select custom field. Example: Multi select Values = A,B,C Record 1 - A,C Record 2 - A,B,C Expected search results: A Count of 2 B Count of 1 C Count of 2
b
you can make a formula that has a value when a select value appears in your multiselect column (INSTR would be my choice), then use summary columns to do your grouping / summing