Skip to content

Instantly share code, notes, and snippets.

@floofydugong

floofydugong/test.sql

Created December 22, 2018 01:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save floofydugong/815c4a630e8d8a01d037c59dd6fd4fed to your computer and use it in GitHub Desktop.
Save floofydugong/815c4a630e8d8a01d037c59dd6fd4fed to your computer and use it in GitHub Desktop.
Download ZIP
test
Raw
test.sql
CASE
WHEN t.calltype = 'Inbound' AND t.type = 'Inbound' THEN 'Call'
WHEN t.calltype = 'Inbound' AND t.type IS NULL AND t.calldurationinseconds >= 90 THEN 'Conversation'
WHEN t.calltype = 'Outbound' AND t.type IS NULL AND t.calldurationinseconds >= 90 THEN 'Conversation'
WHEN t.type IS NOT NULL THEN t.type
ELSE 'Call'
END AS SALESFORCE_TaskTypeImputed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment