Unique Count

[Learner09]

Hello All,

I am trying to design an Alteryx flow for a unique customer count. Please see the details in the attached file and advise.

[Emil_Kos]

Hi @Learner09,

I have prepared a workflow for you:

The output:

If this was helpful please mark my post as a solution!

[AngelosPachis]

Hi @Learner09 

You can use a multi-row formula tool to count the different records per customer and then assign the flag with a formula tool

Regards,

Angelos

[echuong1 · Accepted solution]

I believe I've calculated what you're looking for. Similar to your other question, there are multiple ways to achieve this. I think the easiest is with a multi-row.

I did a group by on customer code. If the row-1 of customer code is null (which would occur for the first in the set), and the category is project or new, then it'll be marked with a 1. Otherwise, a 0.

[Learner09]

@echuong1  Thanks a lot its worked!

[SeanAdams]

Just for completeness - you can also use a tile tool to do record IDs per grouping of clients.

@MattD has a great article here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Tile/ta-p/30235 on using the tile tool this way.