1

I have an issue which I'm trying to solve. We contact customers a number of times during an application. We don't count how many times we call them. I want to get an SQL statement which this by date.

Attached is an image of how the column should appear, with the inserted column in yellow. Would be amazing to see this statement!

thanks Matt

enter image description here

  • Where is the call information stored? Are your call records stored inside of a separate DE? – Gortonington Jun 7 '18 at 13:15
  • Two images provided seem to be identical. Am I missing something? – Ranga Jun 7 '18 at 13:16
  • @Gortonington all records are in the same table – Matthew Barb Jun 7 '18 at 22:53
  • @Ranga, sorry i put in the image twice accidently! – Matthew Barb Jun 7 '18 at 22:54
  • 1
    You should be able to do something like: select count(id), Email From ObjectName Group By Email – Ranga Jun 8 '18 at 8:18
1

You should be able to do something like:

[select count(Id), Email From ObjectName Group By Email]

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.