Summarize tool

[gavinwong]

Hi Community,

absolutely new in this. need abit of help. 

Attached is the file that I am trying with the Summarize tool.

This is something I would use very frequently due to the number of unique records I need to count each time.

In this very simple setup,

I am expecting the following results

4 unique IDs (which is correct)

4 distinct sales because there 4 different sales numbers (why is it counting 5 ? )

4 names are correct

4 months ie there are 4 different months jan feb mar april ( why is it counting 5 ?)

2 Married (either yes or no, why 3 ?)

4 distinct years because 5,8,9,7 are 4 different numbers. ( why 5 ?)

Appreciate any help given

[gavinwong]

Here it is

[LordNeilLord]

Hey @gavinwong,

Would you be able to send a packaged workflow so the data is included (Options --> Export Workflow)?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[gavinwong]

attached is the packaged file.

[LordNeilLord]

@gavinwong that's still the normal workflow, it will have the file extension yxzp

[gavinwong]

here it is.. sorry am very new in this.

[LordNeilLord · Accepted solution]

Hey @gavinwong,

CountDistinct actually counts NULL as an entry. If you wish to disregard any null values you need to use CountDistinctNonNull...this will give you the values you are looking for.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[gavinwong]

Ahhhh ! understand now. Thanks so much. Slightly different from how tableau handles Null

[zkhadi]

Hi

How can I summarize how many flights an individual had? 

How can I count how many flights one individual has taken? 

For example - I need my data to look like this (below)

Ahil - days - 10 - Flights - 4 

[Storm]

Hello @zkhadi:

I don't fully understand what you are trying to do / what your issue is.    Is it possible for you to give a few example rows of data and show what the output should look like?