2 Replies Latest reply on Nov 18, 2012 5:25 AM by George Perros

Want to calculate total instances of specific string values in a field

George Perros Nov 17, 2012 6:16 AM

Want to calculate the total instances of string values to generate histograms or similar output. This would be equipvalent to creating a calculation to return the number of instances that office tables are ordered in the Excel SuperStore example file. Note that there are no sales data associated with these string values, so computing an average price, etc, to use in the calculation is not a viable approach,

1. Re: Want to calculate total instances of specific string values in a field

Shawn Wallwork Nov 17, 2012 6:42 AM (in response to George Perros)
George, I couldn't find the office tables, so I used Office Star products instead. Here's the calc. I used:

IF CONTAINS([Product Name],'Office Star') THEN 1 ELSE 0 END

Workbook attached. Is this what you're looking for?

--Shawn

Count Office.twbx.zip 1.1 MB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Want to calculate total instances of specific string values in a field

George Perros Nov 18, 2012 5:25 AM (in response to Shawn Wallwork)

Thanks, Shawn. I can work with this.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Want to calculate total instances of specific string values in a field

1. Re: Want to calculate total instances of specific string values in a field

2. Re: Want to calculate total instances of specific string values in a field

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account