Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Amelia,
why can't try it out storing in variables.
Sounds great! How would I accomplish this?
So you get multiple Stdev which you want to add up? Can you share a sample where you are trying to do this?
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............
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