Report: Opportunities with Rel Map Status
Reports on open opportunities, closing CFY, and their Altify relationship map status
Specification:
- Report Type: AltfRep_Opportunities_with_Map_Summary
- Format: Summary
- Group By:
- Opportunity > Owner
- Rel Map Status (bucket field)
- Stage (bucket field)
- Bucket Fields:
- Bucket Name: Rel Map Status
- Source Field: Opportunity > Altify Opportunity > Relationships Status (type: picklist)
- Bucket Remaining Values as Other: false
Bucket Values Basic Map Red Good Map Amber; Green; - Bucket Name: Stage
- Source Field: Opportunity > Probability (type: number)
- Bucket Remaining Values as Other: false
Bucket Values Lost <= 0 Early Stage > 0 and <= 20 Mid Stage > 20 and <= 70 Late Stage > 70 and <= 99 Won > 99 - Time Frame Filter:
Column Interval Opportunity > CloseDate Range: Current FY - Other Filters:
Column Operator Value 1. Opportunity > Closed equals false - Row-level Formula:
- Name: Is Good Map (type: Number; api name: CDF1)
- Description: 1 for opps with Amber/Green status, 0 for Red status or no map
- Formula: IF(OR( NULLVALUE(Opportunity.ALTF__Altify_Opportunity__c.ALTF__Relationship_Map_Contact_Count__c, 0) == 0, ISPICKVAL(Opportunity.ALTF__Altify_Opportunity__c.ALTF__Relationships_Status__c, 'Red')), 0, 1)
- Summary Formulas:
Formula DataType Calculation # Opportunities number RowCount % Opps with Good Rel Maps percent IF (RowCount == 0, 0, CDF1:SUM / RowCount) - Report Columns:
- Opportunity > Name
- Opportunity > Stage
- Opportunity > Amount
- Opportunity > CloseDate
- Opportunity > Altify Opportunity > Relationship Map Contact Count
- Opportunity > Altify Opportunity > Relationship Map Key Player Count
- Opportunity > Altify Opportunity > Rel Map Supportive Key Player Count
- Opportunity > Altify Opportunity > Rel Map Key Roles Uncovered Count
- Opportunity > Altify Opportunity > Relationships Status
- Opportunity > Altify Opportunity > Relationships Score
- Row-level formula field (see definition on report page)