Two different controls to be applied on two separate visualizations on one dashboard

Elastic Stack Kibana
1

Hi,

I'm trying create dashboard which will allow users to compare two, the same graphs showing hourly jobs distribution break down by date.
The goal is to apply two, different dates on each graph using controls - I know I can do it manually on each visual, but this is no go scenario.

Tried to place the same data in to separate indexes, data views - trick with ignore filters and lucene OR filter did not help me as well.

Do you guys have any ideas on how I could tackle it?

2

Hi @rubic,

Welcome back! Can you confirm which version of Kibana you are using, which visualization type you are using (Lens or other) and why the manual approach is a no-go option?

Let us know!

3

Hi @carly.richmond, thanks for reply!

I'm using Lens as visualization type, but it is not a must - I can recreate it to any other type if needed. We are currently on Kibana v 8.18.2

I simplified description of my case to maximum, just to make it as clear as possible. Target solution will contain 6 different visuals per both: baseline and reference date. Number of visuals implicates 12, different manipulations which would be over complicated for non technical recipients of the dashboard - that is why it is no go scenario in this case :frowning:

I hope it is a little bit more clear now :slight_smile:

4

Hello @rubic
Could you please confirm if you want to compare data for any specific range?

Like if we want to compare can use below logic :

Step 1 : Add similar metric for comparison -

image
image1548×541 52.1 KB

Step 2 : for the second metric use below configuration , use timeshift as per your need 1d,1w,1m

image
image1567×544 51.8 KB

So in same graph it compares count of today with yesterday.

image
image1024×415 27.3 KB

Hope it helps.

Thanks!!

5

Thanks @Tortoise, unfortunately proposed solution won't solve my issue either.

My aim was to use controls - one on a "baseline" date field from index a, second on reference date field from index b. Sets of visuals are exactly the same, I would like to see baseline data on one set and reference data on the other one.
Tried many different things already including ignore filters, switching from kql to lucene combining / splitting data in indexes / data views etc.
Without success so far.

6

Hi @rubic,

Have you considered a custom visualization using Vega if @Tortoise's suggestion or having separate visualization controls are no-go options ? That way you have full control over the visualization and can in fact have custom event handling interactions.