Outgoing Players by Licence Seniority

What it shows

This chart displays outgoing players (those who left the sport) grouped by their licence seniority - how many years they held a licence before leaving.

Definitions

• Outgoing player: A player marked as inactive (status_id = 'I') whose last licence has expired
• Licence seniority: The number of years between the player's first and last licence

Seniority categories

• New (first year): Players who left in their first year
• 1 year: Players with exactly 1 year of membership
• 2-3 years: Players with 2-3 years of membership
• 4-5 years: Players with 4-5 years of membership
• 6-10 years: Players with 6-10 years of membership
• 11+ years: Long-term members with 11+ years

Data scope

Filters:

• Club: Filter by specific club or view all clubs
• Age Category: Filter by age group

Exclusions:

• International players
• Federation clubs (Swiss Squash, PSA)

Special rules:

• Adults (18+): both yearly and free licences are counted
• Juniors (<18): yearly licences always counted; free licences only if player attended more than 1 course