Overlay timeseries for different date fields within a same index

Elastic Stack Kibana
1

Hi,
problem: say i have an index were documents have a "createdOn" and a "publishedOn" fields.
I want to draw two time series within a same plot, displaying the histogram counts for the two different fields. Then I can see the distribution of when were, say, blog posts created and when were they published.
All timeseries visualizations that I have check in Kibana want you to chose one and only one date field...
I am overlooking anything?

thanks

2

Hi @IvanHerreros

You can do this easily with the new Lens visualization builder, released in Kibana 7.5. If you're using an older version, you could also achieve this using TSVB or Timelion.

3

Hi @Bargs,
I am afraid it isn't that easy :frowning:

To make it clearer:

Easy (can be done any of the ways you mention and a few more):

  • A single visualization including:
    • line with count of blog posts created according to date of creation
    • line with count of blog posts published according to date of creation

Not easy (I am afraid it CAN'T be done any of the ways you mention):

  • A single visualization including:
    • line with count blog posts created according to the date of creation
    • line with count blog posts published according to the date of publication

You can just assume that published, created (booleans) and date of creation and publication (dates) are fields that appear in all documents of a given index.

4

@IvanHerreros unless I am misunderstanding, you should be able to do what you want in TSVB. You can have multiple series in a single TSVB chart based on different index patterns, time fields, and filters. I've created a screenshot highlighting the relevant config options:

image
image3260×1516 272 KB

2 Likes
5

Ok, thanks a lot. Yes, I did not see the override part. I just noticed the "Panel options" tab, where you seem to fix determine the same index pattern for all series.

Thank you. It is indeed practical to be able to work with more than one index in a same visualization.

2 Likes
6

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