Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summarize tool

gavinwong
7 - Meteor

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

12 REPLIES 12
gavinwong
7 - Meteor
Here it is
LordNeilLord
15 - Aurora

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
7 - Meteor

attached is the packaged file.

LordNeilLord
15 - Aurora

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

gavinwong
7 - Meteor

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

LordNeilLord
15 - Aurora

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.

 

CountDNonNull.png@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

gavinwong
7 - Meteor

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

zkhadi
7 - Meteor

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 

 

Capture 2.JPG

Storm
9 - Comet

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?

Labels