TSVB aggregate timestamp interval backward, not forward

pjago · February 17, 2022, 9:07pm

Hello!

Is it possible to aggregate documents through TSVB, or Kibana by all means, where instead of grouping the timestamp forward, we do it backwads?

And as such, instead of dropping the last bucket we would drop the first bucket, since the last one will actually use documents at the bucket timestamp and previous timestamps, not following.

Tomo_M · February 20, 2022, 3:15pm

They are all based on date histogram aggregation in Elasticsearch and it has no option to "backwards" bucketing.

stephenb · February 20, 2022, 4:35pm

Hi @pjago Welcome to the community!

I think I get what you are asking ... can the buckets start from now and be defined from newest to oldest time... unfortunately we do not have that option right now... as far as I know.

The earliest time in the time range marks the time of the first / oldest / beginning buckets and the buckets are calculated forward from that point forward... which often leads to a partial "Last / Newest" Bucket that is why the option "Drop Last Bucket is there ...

In short TSVB does not support what you are asking for.

wlisikpl · February 20, 2022, 5:40pm

Maybe its time to start working on this? I also would love to see this implemented.

stephenb · February 20, 2022, 5:42pm

Please feel free to open a feature request in the Kibana repo.

wlisikpl · February 20, 2022, 5:50pm

@stephenb will not do this; Id rather clone, develop it myself than open FR.

system · March 20, 2022, 5:51pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.