AnsweredAssumed Answered

Comparing Different Records From the Same Field

Question asked by yiningw on Nov 12, 2015
Latest reply on Nov 12, 2015 by IT_User

There are two parts to the question.

If I have 3 sellers, John, Mary and Susie, under the field "sellerID", and I want to have a choice to compare each seller's average sales next to the average sales of all of them combined, how would I go about that?

 

For example, John sold an average of 5 apples and 3 oranges a day, Mary sold 2 apples and 5 oranges, and Susie sold one each. I want to display on one side of a layout that average of John's sales (5 and 3), and on the other side of the same layout the average of all sales ((5+2+1)/3) and ((3+5+1)/3). In other words, the left hand side would be based on finds, but the right hand side would be static.

 

Is there also an option for me to choose whether I want to see Mary's average sales compared against all as well as Susie's? I'm aware of the drop down option but I'm not sure how to implement a proper script so that clicking on the records will perform those finds.

 

Thanks!

Outcomes