
1. Re: Show statistical description (mean, median, std deviation) for table
Abdul Munaf Oct 10, 2019 9:29 PM (in response to Chris Tan)1 of 1 people found this helpful 
2. Re: Show statistical description (mean, median, std deviation) for table
Manjula Muppavaram Oct 10, 2019 9:44 PM (in response to Chris Tan)1 of 1 people found this helpfulHi Chris,
Do you want as below snap shots? please do mean and median for sales and drop in details and you will get them in hover. if it is useful mark as useful.
regards,
Manjula

3. Re: Show statistical description (mean, median, std deviation) for table
amar savale Oct 10, 2019 10:43 PM (in response to Chris Tan)Hi,
Please find the below attachment and screenshot, I hope it's useful for you. If Useful then marked as correct and helpful.
Thanks,
Amar D. Savale

Book1_v10.5.twbx 2.5 MB


4. Re: Show statistical description (mean, median, std deviation) for table
Chris Tan Oct 10, 2019 10:56 PM (in response to Abdul Munaf)Hi Abdul Munaf,
yes, your visualization is okay for me. But how can I get the mean, median and std deviation for the whole column instead of for each cell?

5. Re: Show statistical description (mean, median, std deviation) for table
Chris Tan Oct 10, 2019 11:03 PM (in response to amar savale)Hi Amar, yes, your answer is really close to what I want
But sorry that I didn't say it clearly, I wish to have the mean, median, std for the whole column, instead of particular cell. So in my example, I wish to have `mean` , `median` and `std` for `sum(sales)`. It like the grand total of that column 
6. Re: Show statistical description (mean, median, std deviation) for table
Chris Tan Oct 10, 2019 11:05 PM (in response to Manjula Muppavaram)Hi Manjula,
Amar's answer is the closest to what I want, and my reply to that is what I really want.

7. Re: Show statistical description (mean, median, std deviation) for table
amar savale Oct 11, 2019 1:04 AM (in response to Chris Tan)Hi,
Please find the belowupdated solution, I hope it will useful for you.
Refer Below Calculations:
Category Wise Mean,Mdiean,STDEV
Mean: { FIXED [Category]:SUM([Sales])/COUNT([State])}
Median: { FIXED [Category]:MEDIAN([Sales])}
STDEV: { FIXED [Category]:STDEV([Sales])}
State Wise Mean,Median,STDEV
Mean: { FIXED [State]:SUM([Sales])/COUNT([State])}
Median: { FIXED [State]:MEDIAN([Sales])}
STDEV: { FIXED [State]:STDEV([Sales])}
Thanks,
Amar D. Savale

Updated.twbx 2.5 MB
