# Exclude months with no value from Report **URL:** \ **Category:** HubSpot Ideas\ **Tags:** reports\ **Created:** [August 21, 2020, 7:10am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462 "2020-08-21T07:10:27Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![smatthew](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/smatthew/32/58551_2.png) [@smatthew](https://community.hubspot.com/u/smatthew)\ **Post date:** [August 21, 2020, 7:10am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/1 "2020-08-21T07:10:27Z")
A great addition to HubSpot’s reporting tool would be the ability to exclude dates that have no value from a report. For example, if I am creating a report which spans over 12 months but 4 out of those 12 months have no value, I would have the option to exclude them from my report for the purpose of uniformity i.e. not have a lot of gaps/blank values in my report. Sikemi Matthew Customer Support Specialist HubSpot ---
**Author:** ![mohsen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mohsen/32/86357_2.png) [@mohsen](https://community.hubspot.com/u/mohsen)\ **Post date:** [August 21, 2020, 10:45am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/2 "2020-08-21T10:45:53Z")
100% needed. Lack of this feature has made us skip presenting some reports as its not user friendly and doesnt add value. This feature can’t come fast enough ---
**Author:** ![OBurns](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/oburns/32/14727_2.png) [@OBurns](https://community.hubspot.com/u/OBurns)\ **Post date:** [September 30, 2021, 9:47am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/3 "2021-09-30T09:47:47Z")
pleaseee.. ---
**Author:** ![GBlecon](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gblecon/32/98997_2.png) [@GBlecon](https://community.hubspot.com/u/GBlecon)\ **Post date:** [October 13, 2021, 6:53am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/4 "2021-10-13T06:53:59Z")
Would be great to have this - excluding months/weeks/ days (rolling or custom ranges) ---
**Author:** ![JWeinstock](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jweinstock/32/35608_2.png) [@JWeinstock](https://community.hubspot.com/u/JWeinstock)\ **Post date:** [October 28, 2021, 9:40pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/5 "2021-10-28T21:40:48Z")
Definitely need this! My boss/team keeps asking about the “no value” and it always makes my reports look less legitimate. ---
**Author:** ![CBishop47](https://avatars.discourse-cdn.com/v4/letter/c/51bf81/32.png) [@CBishop47](https://community.hubspot.com/u/CBishop47)\ **Post date:** [January 13, 2022, 11:27pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/6 "2022-01-13T23:27:28Z")
100% would help to be more concise. ---
**Author:** ![Averyg](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/averyg/32/29215_2.png) [@Averyg](https://community.hubspot.com/u/Averyg)\ **Post date:** [January 31, 2023, 1:39am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/7 "2023-01-31T01:39:16Z")
Agreed that this would be a useful feature for reports. On frequencies of daily/weekly, this would help with the presentation of data. ---
**Author:** ![joshkimber](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joshkimber/32/102710_2.png) [@joshkimber](https://community.hubspot.com/u/joshkimber)\ **Post date:** [February 7, 2023, 11:26pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/8 "2023-02-07T23:26:17Z")
I’m surprised this was suggested 2+ years ago and has not been solved. This is needed. ---
**Author:** ![EAllman](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@EAllman](https://community.hubspot.com/u/EAllman)\ **Post date:** [February 28, 2023, 4:26pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/9 "2023-02-28T16:26:42Z")
create a custom report and add a filter that says “XValue you’re trying to measure = known”. This has been available for years, just a different way to do it other that exclude. ---
**Author:** ![adamhopkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamhopkins/32/5125_2.png) [@adamhopkins](https://community.hubspot.com/u/adamhopkins)\ **Post date:** [November 14, 2023, 2:33pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/10 "2023-11-14T14:33:38Z")
Over 3 years later and still very much needed. Doing a filter that says “XValue you’re trying to measure = known”. Doesn’t work as the dates without value just show as 0. I need a report that just shows the data where the date has data against it. ---
**Author:** ![OMueller7](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OMueller7](https://community.hubspot.com/u/OMueller7)\ **Post date:** [January 15, 2024, 3:57pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/11 "2024-01-15T15:57:39Z")
A report with 15/20 x-axis labels that are empty looks very unprofessional. Not being able to hide non-values seems like a big oversight. ---
**Author:** ![EvanderLee](https://avatars.discourse-cdn.com/v4/letter/e/b5ac83/32.png) [@EvanderLee](https://community.hubspot.com/u/EvanderLee)\ **Post date:** [April 16, 2024, 9:08pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/12 "2024-04-16T21:08:13Z")
This seems like excluding (No Value) data in reporting should be a basic basic feature. Having it in the report makes the report almost useless because it ALWAYS raises questions. What are the No Values? What ARE the values? Why are “No Values” in the report? This happens every single time. Three years and going. ---
**Author:** ![VictorSanz99](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@VictorSanz99](https://community.hubspot.com/u/VictorSanz99)\ **Post date:** [September 25, 2024, 3:55pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/13 "2024-09-25T15:55:05Z")
I think it´s logical, it should be implemented in hubspot reports. ---
**Author:** ![JTod](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@JTod](https://community.hubspot.com/u/JTod)\ **Post date:** [November 13, 2025, 10:09am UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/14 "2025-11-13T10:09:34Z")
This is needed. Kind of ridiculous that it isn’t a thing ---
**Author:** ![KP77](https://avatars.discourse-cdn.com/v4/letter/k/278dde/32.png) [@KP77](https://community.hubspot.com/u/KP77)\ **Post date:** [March 6, 2026, 6:55pm UTC](https://community.hubspot.com/t/exclude-months-with-no-value-from-report/24462/15 "2026-03-06T18:55:55Z")
Cames across this 6 years later looking to see if this reature exists 😅. This would be useful for sure.