Excel Gamma.DIST Function in Alteryx

[BastianB]

Hello there,

I've been searching and trying to replicate this but I can't get the Excel Gamma.Dist function to work in Alteryx. It's supposed to take 4 parameters (x,alpha,beta, cumulative) and display the lower or upper cumulative depending on the cumulative parameter (true or false).

The goal is to find a value "n" after which the confidence intervall of a certain percentage is crossed(for example x>=95% certainty after n attempts). Does anyone know how to approach this?

Edit: I found the excel documentation, can Alteryx work this formular though?

[patrick_digan]

@BastianB I have good news and bad news! The good news is that @jdunkerley79 has built the gamma function into his alteryx abacus formula add ons. Once you install it, you can use the GammaDist function as shown below. The bad news is that the PDF calculation isn't quite right, so I had to add a divide beta at the end. I'll work with James to get it fixed.  I'm attaching a workflow example (which you will obviously have to install the abacus first). 

[santiagorestrepo74]

The Gamma.DIST does not seem to be available in the latest Abacus version 1.4.0.4 (and is not in the Documentation)

What was the last version that had the funcion Gamma.DIST?

[patrick_digan]

Hi @santiagorestrepo74 ! Sorry for the confusion. There hasn't been a release in a really long time. The Gamma is in the latest version of the dll/xml files. you would just need to copy all the dll/xml files to %AlteryxBinDirectory%\RuntimeData\FormulaAddIn on your computer. If you have the admin alteryx install, that would be: C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn. The Non-admin install folder path is: %LocalAppdata%\Alteryx\bin\RuntimeData\FormulaAddIn.

You can download a zip file from github with all of the code:

https://github.com/jdunkerley/AlteryxFormulaAddOns/archive/refs/heads/master.zip

Here is the link to the dll:

https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/AlteryxAbacus.dll

And then the 4 xml files:

https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/DateUtils.xml

https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/MathUtils.xml

https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/MiscUtils.xml

https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/StringUtils.xml

Here is the link to the Gamma documentation:

https://github.com/jdunkerley/AlteryxFormulaAddOns/wiki/Math-Functions-(MathUtils.xml)#gammadist

Hope that helps!