8 Replies Latest reply on Jul 12, 2016 2:28 PM by Jonathan Drummey

# TDT: Excel Functions and Tableau 12/13

Hi All,

Think Data Thursday will take place this week (12/13) at 11:00 am Pacific time. We will be discussing some functions that are commonly done in Excel and how to do them in Tableau. Feel free to post any of these functions that you would like to know how to do or already are able to do and would like to share!

Here is the registration page:

http://www.tableausoftware.com/learn/usergroups/TDT-Dec13-12

See you all on Thursday!

-Tracy

• ###### 1. Re: TDT: Excel Functions and Tableau 12/13

Tracy this sounds interesting. What functions are on the list so far? Thx

--Shawn

• ###### 2. Re: TDT: Excel Functions and Tableau 12/13

So far we've got:

-Vlookup

-concatenate

-if statements

-rank/index

There are tons more, so let me know what else you'd like to discuss!

• ###### 3. Re: TDT: Excel Functions and Tableau 12/13

I know when I was really starting to embrace Tableau I actually had to change my mindset from "how do I do this like I do in Excel" to "What is the analysis I'm actually trying to achieve?"  We had a great presentation about this at TCC this year and I'm hoping to bring some of those presentation resources/summary notes to TDT this week.

• ###### 4. Re: TDT: Excel Functions and Tableau 12/13

Excel functions I'd like to see in Tableau:

1. EOMONTH New Calculation Function - EOMONTH
2. PERCENTILE New Calculation Function - PERCENTILE
3. TEXT New Calculation Function - TEXT
4. SUMPRODUCT (haven't created an idea) - useful for complex sums using multiple criteria
5. RAND (haven't created an idea) - Could possibly be useful for things node diagrams and positioning marks
6. SUBSTITUTE (haven't created an idea)
7. REPT (haven't created an idea) - useful for easy tool tip bar charts.
• ###### 5. Re: TDT: Excel Functions and Tableau 12/13

I would be interested to see someone tackle Excel's TRIMMEAN() function. This has been asked for by other Forum users. There are plenty of analysts in my agency who use it extensively as a quick way to calculate a mean value excluding 1% or 5% of the outlying values for multiple columns.

--Tim

• ###### 6. Re: TDT: Excel Functions and Tableau 12/13

Hi All,

Here is the link to the video this week:

https://tableausoftware.webex.com/tableausoftware/lsr.php?AT=pb&SP=EC&rID=31428602&rKey=75c3f4f4476ac3c7

Also, here is the link to the KB article that Janet was referring to and the Trimmean thread that Dustin referred to:

http://kb.tableausoftware.com/articles/knowledgebase/removing-duplicated-data-after-join

http://community.tableau.com/message/194454

-Tracy

• ###### 7. Re: TDT: Excel Functions and Tableau 12/13

6. SUBSTITUTE (haven't created an idea)

FINDNTH() and REGEXP_EXTRACT_NTH() in Tableau 9 makes replacing nth occurrence easy.