Network Venues Retired = Count of Retire Date during [Time Period]

Count of Active Venues at Beginning of Period = See Below

Underlying Data Model (Source: NetSuite → FiveTran → Snowflake)

Final Looker Output: Dashboard Tile