Group then transpose

Question

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.

Alteryx sample - Measure_the_quality_of_data.yxmd

Raj · Accepted Answer

Find the solution attached.
hope this help.

oyes2704 · Accepted Answer

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.