Count occurences of two columns (Different dates per ID)

[cycyg]

Hello Alteryx Community!!
Would appreciate it if somebody can help me out with the below problem that I am trying to do.
I have an ID and Date field, and want to count the number of occurrences of different dates per ID as mentioned below.

Much appreciated for any help

[apathetichell]

summarize tool:

group by date

Count date

will give you the overall count

multi-row formula will give you each row's count. I'll post a mock up in a second.

[mceleavey]

Hi @cycyg ,

Just a little summarise and multi-row magic:

Workflow attached.

I hope this helps.

M.

[cycyg]

Hi mceleavey,
Thanks for prompt response!!
This solution counts occurrences of the date not taking into account the ID correct?
In my case, I want when ID changes, the count starts from 0 again. 
Below is my output from your solution.

[RaviP · Accepted solution]

Hi @cycyg 

Made slight tweak to @mceleavey solution. Hope this helps

[mceleavey · Accepted solution]

Hi @cycyg ,

Ah, you just need to check the ID grouping field on the multi-row formula for that.

I've applied the change.

M.