Normal distribution probability

RobertPenridge
RobertPenridge Member
in Magic ETL

Does Domo have anything similar to the norm.dist() function in excel or the probnorm() function in SAS? I'm looking to use it in a beastmode or calculated field within views explorer.

norm.dist (excel) - https://support.microsoft.com/en-us/office/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d

probnorm (sas) - https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0am6dtkvnrb09n132vioa1z6oen.htm

If not, what's the best alternative? Importing a table of distributions would solve the problem but means I need to add a bunch of additional steps which I'd rather avoid if possible.

Thanks

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user10110

    Domo doesn't have anything built in to calculate a normal distribution probability. You'd need to calculate it yourself via an algorithm

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user10110

    Domo doesn't have anything built in to calculate a normal distribution probability. You'd need to calculate it yourself via an algorithm

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    ask your CSM to enable the MEDIAN function. There are a handful of statistic functions that can be enabled in anlayzer.


    Also https://datacrew.circle.so/c/developerdomocom-community-edition/supported-functions-in-adrenaline-dataflows-views-and-beast-modes, you might find what you're looking for in Adrenaline DataSet Views.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • RobertPenridge
    RobertPenridge Member

    Thanks @jaeW_at_Onyx . Yeah I stumbled across those function options in the top right corner of the views UI last night. Specifically I was wanting to include 4 observations either side of the current row into the stdev calculation. Unfortunately I think in order to achieve that I need to jump through so many hoops it becomes easier to dump the data from Domo elsewhere, perform the calcs I need, then reimport it.

Categories