Identifying Boxes

[DanMBrx]

Hello All,

I am once again looking to this fantastic community for help.

My organisation has a records inventory which includes boxes of records. Each box has a box number and then the records within that box have a record number. 

I have utilised Alteryx to mass apply retention codes to the records via key word searches. 

Following this I am now looking to gather an overview of which boxes have had retention codes applied to all records, and the ones which do not have codes applied to all records, I want to identify how many records are "blank" in the retention code field within each box.

Thanks,

Dan

[ScottLewis · Accepted solution]

Assuming your Retention Code fields are Null rather than just blank there's a summarize option to do that. 

If they're blank rather than Null you'll need a formula step to adjust that first and then you can do the same thing.

Data fed into that to show what it is doing:

[DanMBrx]

Thank you Scott.