[Timelion] How to perform a discrete integration of signal?

[diogom8 (Diogo Monteiro)]

Hi all

I've recently started to explore the world of Kibana+Timelion and the possibilities seem endless. However, I'm trying to perform some energy analysis, based on a power signal, and couldn't yet find a way to calculate the energy consumption.

For now I've a discrete power signal which is archived in elastic search in a non periodic manner (based on some non-relevant rules). What I've done so far was to plot my power signal points and fit it with .fit(average), resembling a continuous time signal. My final goal is to go from Power to Energy, through some discrete-time integration function.

My idea now would be to discretize this signal, with a defined sampling time, and then apply a discrete integration rule.

Is there a way to do this in Timelion? If not, is there an easy way to create a customized function?

Cheers
Diogo

[thomasneirynck]

hi @diogom8,

I don't think you can resample in Timelion, which it looks like you're asking for as a first step. (after .fit).

I'm also pretty sure Timelion can't integrate either. I'm also not sure how exactly you'd want to express this in a time-series Visualization, but that might be more my limited knowledge of the domain. The closest thing we have to integration would be a cumulative sum, which is supported in both Timelion (https://github.com/elastic/timelion/blob/master/FUNCTIONS.md#cusum), and regular Elasticsearch (https://www.elastic.co/guide/en/elasticsearch/reference/6.2/search-aggregations-pipeline-cumulative-sum-aggregation.html).

[diogom8 (Diogo Monteiro)]

@thomasneirynck , thanks for your reply.

You're right cumulative sum could be close but not exactly integration, so not really useful for the analysis I'm looking for. For instance in graphite, it seems that a bunch of nice functions are provided (http://graphite.readthedocs.io/en/latest/functions.html) but I was keen on performing this analysis with ES. Do you know if ES will provide new functions for Timelion soon?

[thomasneirynck]

@diogom8,

I don't know of any new functions being worked on. It's very unlikely though that new ES-functions would be added to Timelion. In fact, Timelion has its won implementation for these functions, and does not rely on Elasticsearch.