As far as I understand it the join node will join based on timestamps. Since in this case, I'm looking to join based on the value of a tag, I'm not sure the join node has what I'm looking for. "As each data point is received from a parent node it is paired with the next data points from the other parent nodes with a matching timestam"
On Thursday, November 3, 2016 at 5:54:41 PM UTC-7, [email protected] wrote: > > I'm wondering if it would actually be possible to calculate exponential > moving average using a tick script. > > for instance where exponential moving average for number of pings in a > time period would be calculated as follows: > > Multiplier: (2 / (Time periods + 1) ) = (2 / (10 + 1) ) = 0.1818 (18.18%) > > EMA: ((# of pings for some period - last plotted EMA point) x multiplier) + > last plotted EMA point > > > To do this I need to do something like > > > > var currentPings = batch > |query('select sum(count) from telegraf.seven_days.pos_heartbeat') > .every(1m) > .period(1m) > .groupBy(time(1m), 'fingerprint') > .align() > .offset(1m) > > var pingsWithMultiplier = currentPings > |eval(lambda: 2.0 / (10.0 + 1.0), lambda: "sum" + 0.0) > .as('multiplier', 'total') > > var lastEma = batch > |query('select last(avg) from > telegraf.seven_days.pos_heartbeat_ema') > .groupBy('fingerprint') > > ---- at this point I need a way to combine lastEma and pingsWIthMultiplier > nodes on tags where 'fingerprint' == 'fingerprint' --- > > Based on the documentation I've read, there's not currently a good way to > do this. Am I missing something? Thanks in advance for any guidance! > > > -- 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/c81feaf3-eb68-487f-9520-22909dbde8c6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
