# Using Date Comparison Filter: Values for KPI involving 2 objects

**URL:** <https://community.hubspot.com/t/using-date-comparison-filter-values-for-kpi-involving-2-objects/116851>\
**Category:** Dashboards & Reporting\
**Tags:** dashboards\
**Created:** [September 23, 2024, 7:08am UTC](https://community.hubspot.com/t/using-date-comparison-filter-values-for-kpi-involving-2-objects/116851 "2024-09-23T07:08:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PCruz30](https://avatars.discourse-cdn.com/v4/letter/p/df705f/32.png) [@PCruz30](https://community.hubspot.com/u/PCruz30)\
**Post date:** [September 23, 2024, 7:08am UTC](https://community.hubspot.com/t/using-date-comparison-filter-values-for-kpi-involving-2-objects/116851/1 "2024-09-23T07:08:03Z")

</div>

![Sales card.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/b/1bd320b4489837e4048ea71da7433229699e6e41.jpeg)  
Hi! So I wanted to compare the total sales (transactions object) this month vs last month using a KPI card by contact owner (contact object). I can see that we can do it for a transactions object and adjust the date range (which will then adjust my sales value in KPI card), but I would need to join it with a contact object and it’s not letting me at the moment. See card below, but I need to be able to have dashboard-level filter of contact owner.

---

<div class="post-metadata">

**Author:** ![kennedyp](https://avatars.discourse-cdn.com/v4/letter/k/49beb7/32.png) [@kennedyp](https://community.hubspot.com/u/kennedyp)\
**Post date:** [September 23, 2024, 5:37pm UTC](https://community.hubspot.com/t/using-date-comparison-filter-values-for-kpi-involving-2-objects/116851/2 "2024-09-23T17:37:25Z")

</div>

Hi @PCruz30! Welcome to the Community-- happy to have you here 😊

I understand you want to add a Contact owner filter to your Transactions object report. Did you use a single object report or the custom report builder? To filter a custom object report by Contact owner (or any other object property for that matter) we will need to include the Contact object in the data sources.

If you are using a single object report, you will likely need to recreate the report in the [custom report builder](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder?hubs_content=knowledge.hubspot.com/reports/create-custom-reports&hubs_content-cta=Custom%20report%20builder%3A)and include the Contact object.

Please let me know if I did not understand your questions or if you need additional clarification! I am eager to solve this with you.

Best,  
Kennedy

---

<div class="post-metadata">

**Author:** ![Solvethru](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/solvethru/32/3667_2.png) [@Solvethru](https://community.hubspot.com/u/Solvethru)\
**Post date:** [February 20, 2025, 1:40am UTC](https://community.hubspot.com/t/using-date-comparison-filter-values-for-kpi-involving-2-objects/116851/3 "2025-02-20T01:40:56Z")

</div>

Hey @PCruz30 ,

I have a solution to compare any metric over time series events, while filtering by the sales rep. Let me know if you are interested.