# Creating a report on no value

**URL:** <https://community.hubspot.com/t/creating-a-report-on-no-value/49516>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [January 10, 2022, 11:07pm UTC](https://community.hubspot.com/t/creating-a-report-on-no-value/49516 "2022-01-10T23:07:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DEcheverria](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@DEcheverria](https://community.hubspot.com/u/DEcheverria)\
**Post date:** [January 10, 2022, 11:07pm UTC](https://community.hubspot.com/t/creating-a-report-on-no-value/49516/1 "2022-01-10T23:07:37Z")

</div>

How can I create a report showing ‘no value’ for a specific field? I’m trying to do some cleanup after importing our data over, and would like to be able to find out what customers don’t have a specific field filled in so we can do follow up.

---

<div class="post-metadata">

**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\
**Post date:** [January 11, 2022, 5:09am UTC](https://community.hubspot.com/t/creating-a-report-on-no-value/49516/2 "2022-01-11T05:09:08Z")

</div>

Hi @DEcheverria ,  
It’s not possible yet to have a report that shows ‘no value’ for a specific field in HubSpot report. However, I found a similar kind of idea submitted [here](https://community.hubspot.com/t5/HubSpot-Ideas/Exported-report-fields-with-No-Value-should-be-left-blank-they/idi-p/461852). You can upvote it. HubSpot product team review these ideas and work on them.

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.  
Thanks and Regards.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [January 11, 2022, 5:41am UTC](https://community.hubspot.com/t/creating-a-report-on-no-value/49516/3 "2022-01-11T05:41:41Z")

</div>

Hi @DEcheverria,

There are a few different ways to approach this, the by far easiest way would be creating lists (especially if the list of fields is short).

One option would be [creating active lists](https://knowledge.hubspot.com/lists/create-active-or-static-lists). Let’s take for example _First name_, _Last name_, _Phone number_. Create a list named “Incomplete name” with a list filter “_First name_ is unknown OR _Last name_ is unknown”, another list called “Phone number missing” filtering for “_Phone number_ is unknown” etc.

(For a list of contacts who are missing a value in any of the fields, connect the criteria by OR. This could be a recipient list for an email campaign, trying to get these contacts to submit a form with their full information, for example.)

If you’re actually referring to “no value” spelled out instead of an empty field, you would simply filter for “_First name_ is equal to any of no value”.

The same approach works for filtered views (_Menu_ \> _Contacts_ \> _Contacts_ \> _More filters_) and for actual reports (_Menu_ \> _Reports_ \> _Reports_ \> _Create custom report_ \> _Single object_ \> _Contact_).

Let me know if you have any follow-up questions!