
1. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Dan Huff Oct 17, 2013 7:02 PM (in response to Daniel Sturgeon)As of Tableau 8, I do not think that this is possible. I would be glad to be proven wrong but I have just been messing around for a while now trying to even get a factorial to work. I was able to get one but not in a way that would be useful for actual analysis .
I'm sure this will be a heck of a lot easier in Tableau 8.1 with the R integration .
Sorry I don't have an answer for you. Hopefully I'm just wrong and somebody will prove it.
Dan

2. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Joshua Milligan Oct 18, 2013 6:25 AM (in response to Daniel Sturgeon)Daniel,
What is your data source? If you are using a source where you can define your own funcitons you could use the RAWSQL functions for pass through and get factorial results at a row level. (e.g. sql server  SQL Functions  factorial  Stack Overflow).
I don't know of any other way to calculate factorials in Tableau at a Row Level. It is possible with Table Calculations spanning multiple rows of data (is that the method you mentioned, Dan?). But it would be very difficult to use that for further analysis.
Regards,
Joshua

3. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Daniel Sturgeon Oct 18, 2013 6:27 AM (in response to Joshua Milligan)my source is survey data in excel (ugh). So that is out of the question.

4. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Joshua Milligan Oct 18, 2013 6:32 AM (in response to Daniel Sturgeon)Daniel,
I just had another thought. What is the largest number on which you would perform a factorial? If known, you could pregenerate a table a factorial results and possibly join or blend that. It would all depend on your exact scenario as to whether that would even have a chance of working. If you don't mind sharing a packaged workbook (.twbx) with the setup and desired results, I'd be happy to take a look.
Regards,
Joshua

5. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Daniel Sturgeon Oct 18, 2013 6:34 AM (in response to Joshua Milligan)I would love to share, but I cannot. It is medical data.
But that last idea is interesting.
Thanks.

6. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?
Joshua Milligan Oct 18, 2013 6:57 AM (in response to Daniel Sturgeon)You're welcome! Please let me know if it does end up working out.
Joshua