Magic ETL

Magic ETL

Normal distribution probability

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • 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

  • 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!**
  • 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"
  • 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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In