TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Standard Deviation and Median on Summary Columns
I would like Standard Deviation and Median choices on Summary Columns for different calculations.

Blake Cabot

Blake Cabot
Date Created
4/9/2013 3:36:05 PM
Date Updated
12/22/2020 6:44:56 AM
In Development
Promoted By
Robert GustavssonScott MillerGii Systems
Rick CogleyBlake CabotPhilipp Matuschka (MMB)
basenineSam Parish
Sam Parish 8/3/2012 6:55:31 AM
For years I've been avoiding this, but now have the regular need for standard deviation functionality in our civil engineering reports. Doing a side table in excel is a waste of time (and wouldn't be necessary if this existed). I'm sure the business folk probably could use it from time to time as well... It makes your reports real legit too. Anybody else?
basenine 8/3/2012 7:05:00 AM
Definitely - great for comparison reports.
These graphs are a must for Educational Institutions too - for some reason, they love them!

At the moment I'm manipulating data using a third party web service... works ok but brings up security risks and attentions within the page
Evgen Goncharov  Staff  4/10/2013 9:47:46 AM
@Blake, can you provide some real-life example(s) of possible "Standard Deviation" and/or "Median" usage.
Slava Shinderov  Staff  4/10/2013 10:14:48 AM
Merged with:
545 - Standard Deviation
Slava Shinderov  Staff  4/11/2013 9:19:36 AM
We've added following aggregate functions:

* Standard Deviation
* Population Standard Deviation
* Variance
* Population Variance
Rick Cogley 4/15/2013 1:28:09 AM
Thank you.
Blake Cabot 3/20/2015 7:32:26 AM
Is Median in development?
Scott Miller 8/21/2015 9:40:56 AM
Hi Evgen

You asked for an example of Median. I am calculating Mileage Rates which change once a certain threshold is reached. The formula in excel is:-

=[Miles]*[Below Threshold Rate]-MEDIAN(0,[Miles],[Running Mileage Total]-[Mileage Threshold])*([Below Threshold Rate]-[Above Threshold Rate])

Slava Shinderov  Staff  8/21/2015 10:28:39 AM
@Scott please try following formula for calculating median of 3 numbers:

(n1 + n2 + n3) - min(n1, n2, n3) - max(n1, n2, n3)

Scott Miller 12/22/2020 6:40:02 AM
I have managed to overcome this issue by using Integromat. I have calculated Mean, Margin of Error, XIRR and many over weird and wonderful calculations.

You need to create a Webhook in Integromat and pass the data to a Google Sheets Module. You can actually pass the calculation into the Google Sheet '=Median(1. DATA)' where [Data] in this example is a summary column of all the scores (concatenated) . You theN use the HTTP Module to POST back to TD
Scott Miller 12/22/2020 6:44:56 AM
Just realised I said 'I have calculated Mean' should read ' I have calculated Median' 😊
Back to Search Results