Sounds like an excellent candidate for a user-defined function <https://docs.influxdata.com/kapacitor/v1.1/nodes/u_d_f_node/> in Kapacitor.
On Sun, Nov 13, 2016 at 5:42 PM, Peter Booth <[email protected]> wrote: > Wondering if anyone has a solution to this? > > > I primarily use influxDB to store software and hardware latencies. > > It's well understood that latencies are not normally distributed. This > means that, if we want to measure the variability of latencies, then the > well-known standard deviation is a bad metric to use. (see > https://www.infoq.com/presentations/latency-pitfalls ). > > There are a number of alternative measures of scale that work well for > data that isn't normally distributed (see https://en.wikipedia.org/ > wiki/Robust_measures_of_scale ). The median absolute deviation isn't the > best, but it is relatively simple to compute and conceptualize. (See > https://en.wikipedia.org/wiki/Median_absolute_deviation) . > > I can compute the deviation from the median but, in the absence of an > abs() or sqrt() function, it's not obvious how to compute the absolute > deviation from the median, which is a precursor to computing the MAD. Can > anyone suggest how to compute MAD within influxDB? > > Peter > > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/bc0f5e3b-4f29-4d18-9bb1-c1f78ca87690%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/bc0f5e3b-4f29-4d18-9bb1-c1f78ca87690%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvMyGCU6bCt3dK71oa3GXfeH7gnTFR_0zah1QR2Z4rEG8g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
