header
Solved

Question. Listing 'External Recipients' or 'Internal Recipients' as Single Line Entries, rather than Comma Separated?

  • 29 January 2021
  • 2 replies
  • 101 views

Userlevel 7
Badge

Hello!

 

This recently came up as a report request to me, to be able to populate a report based on the ‘External Recipients’ field.  However, with it being a comma separated field - moving them to singe lines to get graph type reporting...isn’t a thing.

 

Looking up another post, I came across “Ability to Report on Internal Attendees from Activity Timeline” in which @HollySimmons asked the same and gave an awesome example!

 

@sai_ram the results of these fields are comma separated strings, if I wanted to split by internal attendees but only have one person on each row how can I do that? 

 

Example:

X attended 3 meetings on their own
Y attended 2 meetings on their own
X & Y both attended 1 together. 

Current output: 

X - 3
Y - 2
X, Y - 1

Desired output:
X - 4 
Y - 3

 

Thank you all!

 

[It would also be wonderful if on the pivot function in Rules Engine, if we could pivot based on comma-separated fields]

icon

Best answer by heather_hansen 29 January 2021, 21:43

@sagan_sherlin you should have an Activity Attendees object that will split them up into separate lines.

View original

2 replies

Userlevel 7
Badge +2

@sagan_sherlin you should have an Activity Attendees object that will split them up into separate lines.

Userlevel 7
Badge

@heather_hansen New rabbit hole time! Thank you!! =) 

Reply