Câu 19: Salesforce Certified Tableau Data Analyst

A Data Analyst has a data source with row data for service calls and their activity log. Which calculation allows the analyst to count the calls that have never had a technician assigned to them?

1. A. COUNT ( IF {INCLUDE [Activity Name]: NOT ‘Assign Technician’ } THEN [Call ID] END )
2. B. SUM( {FIXED [Call ID]: IF MAX( [Activity Name]= ‘Assign Technician’) THEN 0 ELSE 1 END } ) — đáp án hiện tại
3. C. COUNT( {FIXED [Call ID]: IF [Activity Name]<> ‘Assign Technician’ THEN 1 ELSE 0 END } )
4. D. SUM( {INCLUDE [Activity Name]: COUNT(IF [Activity Name] <> ‘Assign Technician’ THEN 1 END) } )