Cummulative count

[rprashar]

Hi,

Is there any way in which I can find the week over week cummulative distinct count of the IDs using any of the Alteryx tools. I have attached the scenario below:-
I can do this in SQL by using self join but is there any way of achieving this is Alteryx. Please let me know.
Thanks

[JohnJPS · Accepted solution]

Hi @rprashar,

Just for completeness, I've modified the solution I provided earlier to account for missing weeks; (attached, and you'll have to tweak the version as described earlier to run on your version).

John