Report: SP User Activity Last 90 Days

Shows, by User, the number of views and updates on Process pages in the last 90 days

Specification:

• Report Type: AltfRep_Opportunities_with_without_Altify_Logs
• Format: Summary
  
• Group By:
  • Altify Log > Log Type
  • Altify Log > User > Name


• Time Frame Filter:

  Column	Interval
  Opportunity > CreatedDate	Range: All Time



• Other Filters:

  Column	Operator	Value
  1. Opportunity > Altify Sales Process Status	equals	Has Sales Process
  2. Altify Log > Log Date	equals	LAST 90 DAYS
  3. Altify Log > Page	equals	Process



• Cross Filters: Opportunity with Altify Log

  Column	Operator	Value
  1. Altify Log > Log Date	equals	LAST 90 DAYS
  2. Altify Log > Page	equals	Process



• Summary Formulas:

  Formula	DataType	Calculation
  # Logs	number	ALTF__Log__c.Log_Count__c:SUM
  # Users	number	ALTF__Log__c.User_ID_for_Reports__c:UNIQUE
  # Days with SP Activity	number	ALTF__Log__c.CreatedDate:UNIQUE



• Report Columns:
  • Altify Log > User > Manager
  • Opportunity > Owner
  • Opportunity > Name
  • Opportunity > Altify Opportunity > Sales Process Name
  • Opportunity > Amount
  • Opportunity > Altify Reporting Amount
  • Opportunity > Stage
  • Opportunity > CloseDate
  • Altify Log > Log Date
  • Altify Log > Page