3 Replies Latest reply: Aug 4, 2016 10:33 AM by Jarrad Murray

Standard deviation with aggregate set analysis

Hi All,

I am trying to apply set analysis to a standard deviation equation which uses an aggregate function.  I am having real difficulty getting this to work correctly and would greatly appreciate and assistance or guidance.

The equation that I am using is

Stdev(aggr(sum({<PODGroup4Description = {'AandE'}, MonthKey = {'<=\$(vMonthPosition)'}>}ActivityActual), MonthKey, ActivityActual))

The variable \$(vMonthPosition) = 13  but will be calculated within the application to allow it to be dynamic.

This equation gives me a figure of 262 for the standard deviation instead of the 108 I am expecting.

Looking at the comments about the aggregate function I need to apply the set analysis within the outside of the aggregate but when I do this it errors and gives me nothing.

Does anyone have an idea as to where I am going wrong with this or what I might be able to do to fix it.

Kind Regards

• Re: Standard deviation with aggregate set analysis

You're doing two completely different aggregations. One over only MonthYear and the other over MonthYear and ActivityActual. If you aggregate both over MonthYear and ActivityActual or over MonthKey and ActivityActual or over only MonthKey or only over MonthYear then you'll get the same results.

• Re: Standard deviation with aggregate set analysis

That's fix it.

Thank you very much.

• Re: Standard deviation with aggregate set analysis

I think you should use a mastercalendar! then its really easy to filter the daterange.

See attached sample qvw.

hope this helps!