Aggregate of an Aggregate function

[#1]

Hello Experts! I could use some help-

I’m trying to create an aggregate function of an aggregate function. See below:

Original equation:

X =stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee))

How I want to augment it:

Y = X/sum(X)

To become this final equation:

= stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) / sum(stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) )

  Because I’m already using aggregate functions to take standard deviations of each of these summed values, I can’t perform another aggregation on top of it. Do y’all have any suggestions about how to proceed?

Thanks-

Amelia

[yoganantha321]

Amelia,

why can't try it out storing in variables.

[#3]

Sounds great! How would I accomplish this?

[sunny_talwar]

So you get multiple Stdev which you want to add up? Can you share a sample where you are trying to do this?

[yoganantha321]

Amelia,

just store the expression for 'x' in variable.

example let vX=stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) and expression as vX/sum(vX)

the above said is an example you can try with this............

[#6]

Sounds like this should work!

However, I'm not gathering information from a static source- the data that is being used to determine standard deviation is constantly being added and filtered by different categories. Will this still achieve my purpose?

Thank you so much-

Amelia