I would like Standard Deviation and Median choices on Summary Columns for different calculations.
thanks, Blake Cabot
Date Created 4/9/2013 3:36:05 PM
Date Updated 12/22/2020 6:44:56 AM
Status In Development
Philipp Matuschka (MMB)
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
Blake Cabot 3/20/2015 7:32:26 AM
Is Median in development?
Scott Miller 8/21/2015 9:40:56 AM
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:-
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' 😊