Issue with Time Filters per Column in Kibana Lens when Global Time Filter is Applied

Elastic Stack Kibana
1

Hello Elastic community!

I am encountering an issue in Kibana Lens and I hope someone can help me resolve it. I am using Kibana Lens to create a data visualization, and I have several columns calculating accumulated values and averages over different time intervals. However, when I apply a global time filter (e.g., "Last 30 days") to my dashboard, the metrics do not respect the individual time filters I set for each column.

My current setup:

  1. Acum Year: Applying a KQL filter date >= "now-1y" AND date < "now".
  2. Acum Month: Applying a KQL filter date >= "now-1M" AND date < "now".
  3. Acum Day: Applying a KQL filter date >= "now-1d" AND date < "now".

The issue:

  • When using the global timepicker in Kibana (for example, selecting "Last 30 days"), the metrics like Acum Year, Acum Month, and Acum Day are not segmented correctly according to the time filter set for each column. Instead, all the values are summed up without considering the individual time filters I set.
  • The result: All metrics show the same values, as the global time filter seems to be overriding the filters applied to each column.

What I have already tried:

  1. Applying the KQL filters directly to each column (Acum Year, Acum Month, Acum Day).
  2. Configuring the metrics to be independent with different time ranges.
  3. Ensuring that the time filters are correctly set in the visualization.
  4. Trying the "Reduced time range" option in Lens formulas (available in newer versions), but the issue persists.

Has anyone else experienced this issue?

I would like to know if anyone has found a solution to make Kibana Lens respect custom time filters per column when using a global time filter. Is there a configuration option that allows me to properly segment the metrics by year, month, and day without the global filter affecting all columns?

Alternative:

If this is not possible in Lens, are there any solutions or alternatives in other visualizations like TSVB or Visualize classic that allow this type of independent segmentation per metric?

image
image2477×673 103 KB

Thanks in advance for your help.

1 Like