Object Set Aggregation

[john_totah]

I’d like Object Set Aggregations to support Standard Deviation so it can be shown on a Metric Card in Workshop.

Example: Standard deviation of the names (x-axis) by count

[Joel]

Had the same issue! Something that worked for me is: (1) using the shortcut formula below, (2) the Workshop variable transformations below to get the square of the std dev (requires x and x^2 to be two columns in the data), and (3) a custom Exponent function from typescript to take the square root (also below).

(1)

Source: https://en.wikipedia.org/wiki/Standard_deviation#Rapid_calculation_methods

(2)

(3)
Raise a number to an exponent

@Function()
public pow(x: Double, y: Double): Double {
    return Math.pow(x, y);
}

[tdyck]

This is on Workshop’s roadmap to complete before the end of the year - stay tuned for updates.

[john_totah]

Thank you both for the support!

[tdyck]

This feature has been released! Workshop now supports percentile, median, standard deviation and variance aggregations.

[Joel]

@tdyck

Found this thread, and +2 to the engineers who added mean and median! While this is still fresh, may I please request mode(s) be added to the aggregation metrics? I needed it recently, was unable to figure it out in TypeScript, and had to make an extra object type just for modes.