Group then transpose

[padawanRZ]

Hello Community,

There's already a sample workflow in the Help section. I'm looking for a similar output but instead of counting all the fields, I want to have it grouped by the User column first then transpose and count the total per User.

Appreciate in advance.

 

[Brankl]

Hi padawanRZ! If I understand right, you're essentially trying to count the number of null rows by user. I'd recommend the following configuration of the summary tool. I don't know of an easy way to get the users across the top instead of in this format, but you could always copy the result in Excel and paste transposed.

[Raj · Accepted solution]

Find the solution attached.
hope this help.

[oyes2704 · Accepted solution]

Hi @padawanRZ ,

You need to count total rows by user and then compare each user statistics.

1. Both Summaries will have USER as Group By

2. Transpose has User as Key

3. Replace Append with a Join by User on both sides

Please see solution attached.