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

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

1 Answer 1

Reset to default
1

You should be able to do something like:

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .