7 Replies Latest reply on Jan 31, 2019 7:44 AM by Luis Rios

# Counts

Hi all, I´m having trouble trying to count the number of certain values.  I have attached an excel which I took from my Tableau sheet but what I want is to count the number of 0 values, the number of 3 values, of 2, etc in the column modification count.  So, for example, I would want a to know how many times the value 3 appears, value 2, value 0.  Can someone help?

Thanks,

Eric

• ###### 1. Re: Counts

Hi, Eric

Can you provide a sample workbook other than excel as it is not your original data?

ZZ

• ###### 2. Re: Counts

please restructure your data into something that can be loaded or submit a TWBX workbook and repost

Thanks

Jim

• ###### 3. Re: Counts

Here is an example workbook.  As you can see in the No. of Modifications I have values of 21, 9, and 0.  I want to know how many 0 occurrences there are, how many 9, 21, etc.

Thanks,

• ###### 4. Re: Counts

Hi Eric,

When you place the 'modification count' pill on the view, click the drop down arrow on the pill and select measure > count

Edit: Here's a screenshot of what you're trying to achieve.

Note that if you have other fields in the view such as 'restaurant', 'item', etc. as is in your example file, these numbers will be calculated differently.

1 of 1 people found this helpful
• ###### 5. Re: Counts

Thanks that helps but the "modification count" is actually a calculated field in my actual data set.  Therefore, I´m still having trouble if I put the measure in the viz it gives me the aggregate total of modifications.

• ###### 6. Re: Counts

Eric - the answer will depend on the calculation you used when you created the "modification count" and the nuber of data sources please share your book that includes the calculation so we can help you

Jim

1 of 1 people found this helpful
• ###### 7. Re: Counts

I do not have Tableau available at the moment, but try the calculation below should return the count for a given figure.

COUNT(IF [No. Modifications]= 21 OR [No. Modifications]= 0 OR [No. Modifications]= 9

THEN [Actual Line Final Qty] ELSE null

END)