Announcements
cancel
Showing results for
Did you mean:
Contributor III

Alternate State Set Analysis Help

Hey everyone,

I am dealing with an issue I cant quite figure out. I have 2 alternate states (State1, State2) and I want to to find the rank with the values of State1, including the aggregated average from State2. See example below:

State 1:

IdValue
110
211
312
414
515

State 2:

IdValue
612
713
814

Result:

IdValueRank
1106
2115
3124
State 2133
4142
5151
16 Replies
Contributor III
Author

How would you add the Standard deviation of the new set, including the "State2" value?

MVP

Check the attached

Contributor III
Author

Sunny,

Sorry to keep this post going:

Is there any way to do this same functionality without using straight tables?

For example, if I just wanted to create a text box with the rank of the aggregated State2 values compared to the State1.

Thanks for the help!

MVP

What would be the output look like in the text box? Can you draw a picture for me?

Contributor III
Author

Using the same data values as above, I would want to be able to to do the following without using tables:

MVP

Getting Average value should be simple

='Average State2 Value' & Chr(10) & Avg({State2} Value)

Still trying to figure out the Rank part

MVP

For rank, try this

='State2 Rank' & Chr(10) & RangeSum(Count(DISTINCT Aggr(If(Sum(Value) > Avg(TOTAL {State2} Value), Id), Id)), 1)