This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Incorta Community
- Discussions
- Dashboards & Analytics Discussions
- Re: Standard Deviation

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Options

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-14-2023 07:56 AM

Hi,

=IFERROR(STDEV.P(BQ14348:CB14348)/AVERAGE(BQ14348:CB14348),0)

Could please let me know how to convert above "STDEV.P" excel function in Incorta.

Solved! Go to Solution.

7 REPLIES 7

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-14-2023 10:38 AM

KHK,

Unfortunately, no we do not have a built in function for this. We have many of the functions that in aggregate support the calculation such as ABS(), AVERAGE() and SQRT(). In a multi pass process it would look something like:

- for each data point x calculate distance from mean, squared: abs((x-avg(x))(x-avg(x)))
- sum each of the above, and divide by count(x)
- sqrt(#2)

However, the easier way to do this is by using an python MV and using a python dataframe function to calculate the STDEV from the elements in the dataframe. Pandas supports something like

df['amount'].std()

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-14-2023 11:05 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

08-28-2023 11:58 PM

Hello JeffW,

I'm working with a dataset where the grouping criteria are determined by specific requirements and are not fixed or limited.

Typically, other aggregate functions operate on the columns designated in the grouping context. Is it possible to apply the stddev() function in a manner similar to other aggregate functions such as sum and average, considering this dynamic grouping?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

03-16-2023 09:25 AM

Adding on to Jeffs approach, if you happen to be more SQL oriented you can alternatively use SparkSQL or Postgres SQL 'STDDEV' Function within a Materialized View.

Output:

Similarly, if we want to show the standard deviation grouped by product in the same scenario here is a simple example.

With Group By:

Output:

Regards,

Zach

Related Content

- Show negative numbers as () in Dashboards & Analytics Discussions
- Internal Query Expression in Administrative Discussions
- Standard Deviation in Dashboards & Analytics Discussions
- Calculation based on Custom calendar and non joined tables in Dashboards & Analytics Discussions
- Performance Analysis of Postgress connection in Data & Schema Discussions