# Reporting on full months only

**URL:** <https://community.hubspot.com/t/reporting-on-full-months-only/126768>\
**Category:** Tips, Tricks & Best Practices\
**Tags:** reports, enterprise\
**Created:** [February 25, 2025, 1:37am UTC](https://community.hubspot.com/t/reporting-on-full-months-only/126768 "2025-02-25T01:37:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marie\_1](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@Marie\_1](https://community.hubspot.com/u/Marie_1)\
**Post date:** [February 25, 2025, 1:37am UTC](https://community.hubspot.com/t/reporting-on-full-months-only/126768/1 "2025-02-25T01:37:16Z")

</div>

Looking for tips on how to create a report that shows full months of data only.

Specifically, I want to see data plotted for last 12 months but don’t want to view any partial months and can’t work out how to do that. ie, if viewing on 12 Feb, only want to see to the end of Jan. I prefer not to have to amend date ranges each month.

I’ve created in Custom Report Builder and presently have the filter set to Create Date is Last 365 days.

X-axis - Create Date - Monthly.

Aggreation - none

Date part - none (I tried using date part as monthly but that then plots a Jan-Dec view regardless of the year, which is confusing to interpret.)

Frequency - Monthly

Sort - Value/Ascending

y-axis Count of contacts

Maybe I’m missing something simple?

---

<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:** [February 25, 2025, 5:26am UTC](https://community.hubspot.com/t/reporting-on-full-months-only/126768/2 "2025-02-25T05:26:45Z")

</div>

Hi [@Marie\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/314633),

For exactly 12 months, this is not possible, no. This would certainly be useful to have and you could request from the product team: [https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot\_Ideas](https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot_Ideas)

As far as workarounds go, setting the date range manually is indeed the best option for now.

Best regards

---

<div class="post-metadata">

**Author:** ![Marie\_1](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@Marie\_1](https://community.hubspot.com/u/Marie_1)\
**Post date:** [February 25, 2025, 5:36am UTC](https://community.hubspot.com/t/reporting-on-full-months-only/126768/3 "2025-02-25T05:36:22Z")

</div>

Thanks @karstenkoehler Appreciate your advice, as always!

---

<div class="post-metadata">

**Author:** ![Marie\_1](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@Marie\_1](https://community.hubspot.com/u/Marie_1)\
**Post date:** [February 25, 2025, 5:37am UTC](https://community.hubspot.com/t/reporting-on-full-months-only/126768/4 "2025-02-25T05:37:34Z")

</div>

Have posted an Idea here:

[https://community.hubspot.com/t5/HubSpot-Ideas/Reporting-on-full-months-only/idi-p/1113979/highlight/true](https://community.hubspot.com/t5/HubSpot-Ideas/Reporting-on-full-months-only/idi-p/1113979/highlight/true)

if anyone else is looking for the same solution please upvote.