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

**URL:** https://discuss.elastic.co/t/issue-with-time-filters-per-column-in-kibana-lens-when-global-time-filter-is-applied/377408
**Category:** Kibana
**Tags:** docker
**Created:** [April 23, 2025, 12:51am UTC](https://discuss.elastic.co/t/issue-with-time-filters-per-column-in-kibana-lens-when-global-time-filter-is-applied/377408 "2025-04-23T00:51:52Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![arrax\_10](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@arrax\_10](https://discuss.elastic.co/u/arrax_10)
#### Post date: [April 23, 2025, 12:51am UTC](https://discuss.elastic.co/t/issue-with-time-filters-per-column-in-kibana-lens-when-global-time-filter-is-applied/377408/1 "2025-04-23T00:51:52Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/4/a/4a3e4a8c6ea93b2b4f5b4029543ccf48a9e9cde3.png)

Thanks in advance for your help.