Function for Triangular dist.

[Atabarezz]

One of the common methods for generalization of different types of normal and beta distributions is triangular.

Though Alteryx doesn't have a function for this, even excel doesn't have this but

• SAS (randgen(x, "Triangle", c)) and
• Mathematica (TriangularDistribution[{min,max},c]) like tools include one.

Can we add something like randtriangular(min,mode,max)?

I have my solution attached, but this will ease the flow...

Best

Montecarlo_triangularand.yxmd

[jdunkerley79]

Stuck together a Formula AddIn to add this:

RAND_TRIANGULAR(RAND(), 1, 4, 10)

Needs to be fed in a uniform random number but will create a triangular distributed one:

To add this download the code from GitHub: https://github.com/jdunkerley/AlteryxFormulaAddOns/blob/master/Random.xml

You need to save this as an xml file in C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn

The function will then be available within Alteryx.

[Atabarezz]

great job!

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!