JSON Occurrence Counter with Percentage Report and 20% Threshold Gate

How it works

1. 1.Run the workflow manually from Run Report (Manual)
2. 2.A Code node emits 12 fictional test items (10 valid + 1 empty value + 1 missing field)
3. 3.Aggregate Counts & Percentages tallies counts, computes percentages, sorts descending
4. 4.A Set node formats fields (value, count, percentage, rank, threshold) retaining other fields
5. 5.IF routes each row to Dominant (>20%) or Minor branch
6. 6.Merge rejoins branches and Build Final Report builds ONE report verifying totals

Use cases

• Analyzing dominant values in local JSON logs or categories
• Distribution report of document/request types before further integrations
• Separating high-frequency categories for downstream n8n processing

Requirements

• n8n 2.45.5 (Manual Trigger, Code, Set, If, Merge, NoOp, Sticky Note)
• No credentials or API calls — local processing only
• To replace sample data: delete Emit Sample Payload and connect a real source with the same item_value schema

Setup and testing in n8n

1. Import the JSON into n8n and run Execute Workflow manually
2. Verify final report: total_items=12, sum_of_counts=12, sum_of_percentages=100
3. Edge case: empty the sample node or pass empty input and confirm the safe empty report
4. Change the threshold in the IF node and Build Final Report and rerun to test both branches

Service Value

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