Does OpenTSDB can perform 'clever' query?

168 Views Asked by At

I really need to know if openTSDB database can perform some clever query. There are no lot of example shared.

For example, i need average for one dataset values, with zero values excluded.

Now i have something like this:

http://localhost:4242/api/query?start=1480892400&end=1483657140&m=sum:32d-avg:site.availability{siteId=73}&arrays=true&ms

This query takes start & end date timestamps, 32 days downsample parametar and 'avg' as average aggregate function, metrics name, tag and response format.

My time data series looks like:

[
  [1483142484722, 210],
  [1483142548883, 203],
  [1483142609002, 0]
]

Etc...

This query returns one single value as expected, that is average of all values in my dataset. I need query that returns average for all, except '0' values, i don't wont zero values affect my calculations.

Can we do something like that in openTSDB ?

0

There are 0 best solutions below