# Opportunities without Appointments Report

**URL:** <https://community.hubspot.com/t/opportunities-without-appointments-report/11171>\
**Category:** Dashboards & Reporting\
**Created:** [December 9, 2018, 3:26pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171 "2018-12-09T15:26:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![DarinSpence](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/darinspence/32/97119_2.png) [@DarinSpence](https://community.hubspot.com/u/DarinSpence)\
**Post date:** [December 9, 2018, 3:26pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/1 "2018-12-09T15:26:41Z")

</div>

How can I create a report that lists opportunities without appointments?

---

<div class="post-metadata">

**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\
**Post date:** [December 9, 2018, 4:29pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/2 "2018-12-09T16:29:06Z")

</div>

![hubspot-crm-contact-opportunities-last-meeting-unknown.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d1f797940b5b74dafbbc1c109bfbe8154b2046da.png)

---

<div class="post-metadata">

**Author:** ![DarinSpence](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/darinspence/32/97119_2.png) [@DarinSpence](https://community.hubspot.com/u/DarinSpence)\
**Post date:** [December 10, 2018, 3:07pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/3 "2018-12-10T15:07:35Z")

</div>

This is what I was needing, thank you!

I was hoping to filter the results to just the contacts where the Last Meeting was \<Today. However, yesterday when I used the ‘today’ filter, the date of 12/9 was entered. Today, the date is still 12/9.

Perhaps there will be some way to use a period (like today, this month, last month, etc) as a filter someday.

Thanks!

 ![Hubspot Saved Filter Snip.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/2X/a/a52421f9cc011a8ab9be893cc36ec749c18733d5.png)

---

<div class="post-metadata">

**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\
**Post date:** [December 10, 2018, 3:59pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/4 "2018-12-10T15:59:59Z")

</div>

Yea … ‘today’ is actually a datepicker option (not a filter per se).

If you’re using HubSpot Marketing Pro you can achieve your desired results using the lists tool which supports rolling dates (i.e., “\<1 Days Ago”).

---

<div class="post-metadata">

**Author:** ![DarinSpence](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/darinspence/32/97119_2.png) [@DarinSpence](https://community.hubspot.com/u/DarinSpence)\
**Post date:** [December 10, 2018, 4:13pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/5 "2018-12-10T16:13:56Z")

</div>

I think this will provide a list of opportunities without appointments. Thanks!

 ![Hubspot Saved Filter on List Snip.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/1/41abb46bd6acaa58da929cdd0245ac2eddee2a41.png)

---

<div class="post-metadata">

**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\
**Post date:** [December 10, 2018, 10:15pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/6 "2018-12-10T22:15:31Z")

</div>

Sorta. Basically, that list will only show contacts …

- associated with a company whose Lifecycle Stage is known

- AND who are associated with open deals

- AND for whom the ‘Last Meeting Booked’ date is ‘\<1 Days Ago’

Just be aware, that _ **future** _ meeting booking dates also qualify as ‘\<1 Days Ago’!

Once you tweak your list criteria the way you like, you can use that list membership as criteria for a view filter. Nice.

Have a great weekend.

---

<div class="post-metadata">

**Author:** ![Arne](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/arne/32/9178_2.png) [@Arne](https://community.hubspot.com/u/Arne)\
**Post date:** [December 25, 2018, 12:10pm UTC](https://community.hubspot.com/t/opportunities-without-appointments-report/11171/7 "2018-12-25T12:10:07Z")

</div>

Can’t answer your question but like to chime in. I‘d like to have a report that shows the deals that pretend to be in the contract negotiation phase but there hasn’t been an evaluation/POC for the product they shall buy from us.