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
Solved! Go to Solution.
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.
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.