forums

Use these forums to ask questions and discuss Tableau.

Counting Unique Values

Posted March 5th, 2008 by bfaulkner
in Tableau Desktop Basics

I am struggling to figure out how to count unique values. I have tried reading the help file on "Defining Unique Values" and I am still stuck.

I have a list transactions that have the following information;
- Amount
- Date
- Supplier
- Department

If I count the suppliers then I get the number of times the a supplier's name shows up in the dataset.

How do I count the number of Unique suppliers?

I know it must be something easy but I am stuck.

Thanks,
Bruce

Add new comment

Comments

On March 5th, 2008 Erin Easter said:
Bruce,

What type of data source are you using? If you are using a local file data source such as Excel, Access, or Text Files you only have the ability to aggregate a field using Count. However, if you extract the data you can aggregate using Count (Distinct).

You can create a Tableau Data Extract by selecting Data > Extract.
reply
On March 6th, 2008 bfaulkner said:

Erin,

I am using Excel. Just gave it a try on the Supplier field and it worked perfectly.

I have never used the Data > Extract feature and didn't even know to look there for the answer.

Thank you very much.

Regards,
Bruce

reply