Tracy this sounds interesting. What functions are on the list so far? Thx
So far we've got:
There are tons more, so let me know what else you'd like to discuss!
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.
Excel functions I'd like to see in Tableau:
- EOMONTH New Calculation Function - EOMONTH
- PERCENTILE New Calculation Function - PERCENTILE
- TEXT New Calculation Function - TEXT
- SUMPRODUCT (haven't created an idea) - useful for complex sums using multiple criteria
- RAND (haven't created an idea) - Could possibly be useful for things node diagrams and positioning marks
- SUBSTITUTE (haven't created an idea)
- REPT (haven't created an idea) - useful for easy tool tip bar charts.
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.
Here is the link to the video this week:
Also, here is the link to the KB article that Janet was referring to and the Trimmean thread that Dustin referred to:
6. SUBSTITUTE (haven't created an idea)
FINDNTH() and REGEXP_EXTRACT_NTH() in Tableau 9 makes replacing nth occurrence easy.
See more about this in The specified item was not found.