6 Replies Latest reply on Oct 18, 2013 6:57 AM by Joshua Milligan

# Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?

I was able to get a chi-square working, but now I also need a Fisher.

Has anyone found a way yet? What I really need is a way to perform factorials which I cannot find.

Thanks!

• ###### 1. Re: Is there a way to perform a Fisher Exact Test (or just factorials)in Tableau?

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?

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?

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?

Daniel,

I just had another thought.  What is the largest number on which you would perform a factorial?  If known, you could pre-generate 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?

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?

You're welcome!  Please let me know if it does end up working out.

-Joshua