-
1. Re: Calculation to count unique occurrences of text strings
Shawn Wallwork Nov 24, 2012 8:10 AM (in response to Stephen Jones)Hi Stephen, you'll need to post a packaged workbook (twbx). The workbook you posted (twb) doesn't have any data in it.
--Shawn
-
2. Re: Calculation to count unique occurrences of text strings
Stephen Jones Nov 24, 2012 8:28 AM (in response to Shawn Wallwork)Thanks, Shawn. Hope this works.
Stephen
-
3. Re: Calculation to count unique occurrences of text strings
Shawn Wallwork Nov 24, 2012 8:46 AM (in response to Stephen Jones)Stephen, the formula basically is:
SUM([Student Credit Hours])/COUNTD([Primary Instructor])
Which gives you the totals you're looking for in your table (see attached). Hope this helps.
--Shawn
-
4. Re: Calculation to count unique occurrences of text strings
Stephen Jones Nov 24, 2012 8:57 AM (in response to Shawn Wallwork)Thank you very much, Shawn. I get it!
In my much larger data set the Excel file has not been imported – it's a live connection to that Excel file – and to use COUNTD I understand I need the data to be imported into Tableau. How do I convert that Excel file (import it into the Tableau file) so that COUNTD is available to me as I perform calculations on the whole file?
Sorry for all the newbie questions.
Stephen
-
5. Re: Calculation to count unique occurrences of text strings
Shawn Wallwork Nov 24, 2012 9:14 AM (in response to Stephen Jones)1 of 1 people found this helpfulStephen, not a problem, we were all newbies. Right-click your data connection, then click Extract Data. This pops up a dialog box. This first time (and most times) go ahead and accept all the defaults by clicking OK. That does it, you'll now be using Tableau's data engine, instead of MS Jet. And now COUNTD() is available. It's also going to be faster. Just remember that is your under-lying data changes you'll need to refresh or change the extract.
Good luck.
--Shawn
-
6. Re: Calculation to count unique occurrences of text strings
Stephen Jones Nov 24, 2012 9:30 AM (in response to Stephen Jones)Again, many thanks, Shawn.
It's early, but here's my gift to you – a Christmas music video. I am the composer. The YouTube version hasn't been seen as much as a previous version on line that reached hundreds of thousands. Hope you enjoy it. Forgive me if you are not a Christian.
http://www.youtube.com/watch?v=fw1BwFp-Ojk
Stephen