Skip to main content
DD-CRM-002-Q033 Medium

Effort spent on lost deals

Append FactActivity and FactActivityLatest first. For the "New business" opportunities Closed Lost in 2025, what is the average number of activities linked to each (OpportunityID)? 2 decimals.
Expected
One number, 2 decimals · KPI card
Tables
FactOpportunity, FactActivity, FactActivityLatest · columns
  • FactOpportunity
  • FactActivity
  • FactActivityLatest
  • OpportunityID
  • OpportunityType
  • Stage
  • CloseDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us