Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

compare values in column to average value

hello! I hope you are well while reading my message! / many thanks for taking the time to help me out!

I have a dimension (number of times a type of furniture is purchased).  And I would like to compare that to the mean (ie how far away from the mean is it).  How would I do that?

So I have:

     Purchase count     how far from mean?

total:       55                         5.5

               1                         ( - 4.5)

                2                         (-3.5)

               3                         (-2.5)

               4                         (-1.5)

               5                         (-.5)

               6                         (.5)

               7                         (1.5)

               8                         (2.5)

               9                         (3.5)

               10                        (4.5)

** So how would I get the numbers in parathesises to be calculated for me?

Thank you!

1 Solution

Accepted Solutions
sunny_talwar

May be like this:


[Purchase Count] - Avg(TOTAL [Purchase Count])

View solution in original post

2 Replies
sunny_talwar

May be like this:


[Purchase Count] - Avg(TOTAL [Purchase Count])

Clever_Anjos
Employee
Employee

If you´re using the same dataset