# How to make the same value appear in two filters

**URL:** <https://community.omni.co/t/how-to-make-the-same-value-appear-in-two-filters/432>\
**Category:** Workbooks\
**Tags:** filtering\
**Created:** [December 9, 2025, 10:55pm UTC](https://community.omni.co/t/how-to-make-the-same-value-appear-in-two-filters/432 "2025-12-09T22:55:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![samp](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/samp/32/520_2.png) [@samp](https://community.omni.co/u/samp)\
**Post date:** [December 9, 2025, 10:55pm UTC](https://community.omni.co/t/how-to-make-the-same-value-appear-in-two-filters/432/1 "2025-12-09T22:55:02Z")

</div>

# The Scenario

You have two date filters, Created At and Sent At. You want them to always be equal (7, 30, 100 days ago) and they are both necessary for your analysis.

# The Solution

Assuming you are working in a Topic, add the following code to every View within that topic:

```auto
compound_date:
    sql: |
      (partition_date >= NVL(DATEADD('day', -2, {{ filters.event_date_filter.range_start }}), '1970-01-01')
      AND 
      partition_date < NVL(DATEADD('day', 2, {{ filters.event_date_filter.range_end }}), '2100-01-01'))
      AND
      (h_server_timestamp >= NVL(DATEADD('day', -2, {{ filters.event_date_filter.range_start }}), '1970-01-01')
      AND
      h_server_timestamp < NVL(DATEADD('day', 2, {{ filters.event_date_filter.range_end }}), '2100-01-01'))
    hidden: true

filters:
  event_date_filter:
    type: timestamp

```

And then in your topic file, add this:  
`always_where_sql: ${v_event_name.compound_date}`

This means that using the event\_date\_filter filter will cause all dates across the topic to be uniform.

Happy building!