Support ticket merge reconciliation calculator

Calculate original ticket records and unique root cases after supplied merge links with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use original ticket records and unique root cases after supplied merge links to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Tickets: ID, parent ID or none, supplied resolved yes/no
A,none,yes B,A,yes C,B,no D,none,no E,none,yes
Merged-case resolution rule: root-only or all-members
root-only
Original ticket records
5
Unique root cases after supplied merge links
3
Records beyond one per root case
2
Resolved root-case share under selected rule (%)
66.666667
Ticket-to-root trace
A: A; B: A; C: A; D: D; E: E

Try another scenario

Tickets: ID, parent ID or none, supplied resolved yes/no
A,none,yes B,A,yes C,B,no D,none,no E,none,yes
Merged-case resolution rule: root-only or all-members
all-members
Original ticket records
5
Unique root cases after supplied merge links
3
Records beyond one per root case
2
Resolved root-case share under selected rule (%)
33.333333
Ticket-to-root trace
A: A; B: A; C: A; D: D; E: E
Calculation method

Calculation method

Original ticket records

Count unique supplied ticket IDs.

Unique root cases after supplied merge links

Follow known parent links to acyclic roots.

Records beyond one per root case

Original records−unique roots.

Resolved root-case share under selected rule (%)

Root-only: use root status. All-members: require every member resolved. Divide qualifying roots by all roots.

Ticket-to-root trace

Show every original ID’s root without merging or deleting a real record.

Symbols and units
a
Tickets: ID, parent ID or none, supplied resolved yes/no
b
Merged-case resolution rule: root-only or all-members

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A supplied parent-link denominator audit with an explicit resolution convention. It does not infer that tickets are duplicates or perform real merges.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Zendesk: response metrics and business-hour definitions; this tool uses its displayed convention ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.