Status x Audience Cross-Tabulation with Marginal Totals

How it works

1. 1.Run the manual trigger; a Code node emits 10 fictional items (9 valid + 1 invalid).
2. 2.The matrix builder cleans values, counts each pairing, computes marginals and grand total, skipping incomplete items.
3. 3.A Set node adds pair_label while keeping all fields.
4. 4.An IF node separates pairs with count > 0 from zero-count pairs.
5. 5.Each branch enters an append Merge on its own input, then a no-op endpoint.

Use cases

• Report sent/failed/queued message counts per audience segment
• Any cross-tab aggregation of two configurable categorical fields
• Spot segments that received zero of a given status via the zero branch

Requirements

• No credentials; everything runs locally
• To change the two fields edit STATUS_FIELD and AUDIENCE_FIELD in the matrix Code node
• To use real data remove the generator node and connect your source

Setup and testing in n8n

1. Import the JSON into n8n and execute from the manual trigger
2. Verify 6 output pairs whose counts sum to 9, matching valid input items
3. Verify the one zero pair (Failed × Individuals) arrives via merge input 1
4. Try empty or field-missing input to see edge handling

Service Value

Ready-made workflow template for automation delivery and service execution.