# NRR report

**URL:** <https://community.hubspot.com/t/nrr-report/52995>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [March 11, 2022, 3:13pm UTC](https://community.hubspot.com/t/nrr-report/52995 "2022-03-11T15:13:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RGelber](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@RGelber](https://community.hubspot.com/u/RGelber)\
**Post date:** [March 11, 2022, 3:13pm UTC](https://community.hubspot.com/t/nrr-report/52995/1 "2022-03-11T15:13:23Z")

</div>

I am trying to create a report that shows a Customer on the X-axis, the value of their contracts (annually) on the Y-axis, and show it year over year. So for example, it will show Company A on the X, then have two different bar measurements, 2021 total contract values and another bar showing 2022 total contract values.

I have tried making this customer report several different ways, but I am having trouble.

Any help would be appreciated.

Thanks,

---

<div class="post-metadata">

**Author:** ![TitiCuisset](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@TitiCuisset](https://community.hubspot.com/u/TitiCuisset)\
**Post date:** [March 14, 2022, 9:21am UTC](https://community.hubspot.com/t/nrr-report/52995/2 "2022-03-14T09:21:00Z")

</div>

Hi @RGelber

Thank you for reaching out.

I want to tag some of our experts on this - @danmoyle @ChrisoKlepke @NicoleSengers do you have any thought for @RGelber on this?

Thank you!

Best

Tiphaine

---

<div class="post-metadata">

**Author:** ![ChrisoKlepke](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisoklepke/32/11213_2.png) [@ChrisoKlepke](https://community.hubspot.com/u/ChrisoKlepke)\
**Post date:** [March 14, 2022, 11:05am UTC](https://community.hubspot.com/t/nrr-report/52995/3 "2022-03-14T11:05:33Z")

</div>

[@TitiCuisset](https://community.hubspot.com/t5/user/viewprofilepage/user-id/89150) , thank you for tagging me again 😉

Hey @RGelber ,

hope I can help you out here. There is a function in the reports tool that can compare the current timeframe with the one before very elegantly. It doesn’t matter in this case if you change it too monthly, yearly or daily. But this feature is only available in the single object report tools. Luckily, you can filter and view the associated company in a deal-based single object report.

This is a report I build with example data. As you can see at the end of the chart, it compares the yearly amount of deals with the year before:

 ![Screen Shot 2022-03-14 at 11.49.58.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/8/68412393535f89da983bf78a1a14d42cfaf27a11.png)

Here are some additional screenshots to get you started:

**Filters**

Of course, you can add some other filters here. Especially something like _Deal Stage is Closed Won_ would make sense.

 ![Screen Shot 2022-03-14 at 11.49.00.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/a/ac8a14efc463bc9794513bcbb38e4d1abaa48cea.png)

**Chart Configuration**

 ![Screen Shot 2022-03-14 at 11.48.52.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/2/20a1889cca4f9778eae7b22495b0624e7c4917bd.png)

**Display Options**

This where you set up the comparison to the time frame before the one you’re displaying. If the timeframe you’re filtering is _last month,_ you will also see the month before that. In this case, it is last year (2021) and the comparison is the year before that, so 2020.

 ![Screen Shot 2022-03-14 at 11.49.22.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/2/02c00cc56e61b50a63dbf9647a488b30ee176544.png)

Let me know if you have any follow-up questions. Otherwise, please consider helping the community with similar questions by marking this post as a solution.

Cheers,

Chriso

---

<div class="post-metadata">

**Author:** ![timo1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/timo1/32/52600_2.png) [@timo1](https://community.hubspot.com/u/timo1)\
**Post date:** [August 14, 2023, 12:38am UTC](https://community.hubspot.com/t/nrr-report/52995/4 "2023-08-14T00:38:43Z")

</div>

Hi @ChrisoKlepke, Is it possible to break this down by CSM rep instead of associated company? We’re trying to figure out each CSM’s NRR progress throughout the year.

---

<div class="post-metadata">

**Author:** ![NicoleSengers](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nicolesengers/32/30704_2.png) [@NicoleSengers](https://community.hubspot.com/u/NicoleSengers)\
**Post date:** [March 14, 2022, 11:21am UTC](https://community.hubspot.com/t/nrr-report/52995/5 "2022-03-14T11:21:29Z")

</div>

Hi @RGelber

The solution from @ChrisoKlepke works really well. I looked at it slightly differently and Suggest you can do associated companies and amount but break down the report by Close date - Year.

 ![Screenshot 2022-03-14 at 13.18.49.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/9/89741909a047d0ead90b22c699b01514cceeb549.png)

Kind regards

Nicole