# Average Deal Size Visualization **URL:** \ **Category:** šŸ’¬ RevOps Discussions\ **Tags:** revops, salesops\ **Created:** [October 8, 2024, 4:06pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906 "2024-10-08T16:06:41Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![msshey](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@msshey](https://community.hubspot.com/u/msshey)\ **Post date:** [October 8, 2024, 4:06pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/1 "2024-10-08T16:06:41Z")
Hello, everyone! šŸ˜Š I need a little help building a report. Iā€™m looking to create something similar to the chart below, but Iā€™d like to include two bars that compare total revenue against our million-dollar goal. It would be great to see both the total income and the percentage towards that goal. If anyone has tips or can guide me on how to set this up, Iā€™d really appreciate it! Thanks in advance! šŸ“ŠšŸ’” ![Screenshot 2024-10-09 at 12.02.44 AM.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/b/4b872ff9442fba81959285a99fb0f3e97a11040b.jpeg) ---
**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:** [October 8, 2024, 4:12pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/2 "2024-10-08T16:12:27Z")
Hi [@msshey\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/838055), Outside of the too right corner of your screenshot, you should see the option to customise the report - which should take you to the custom report builder. In there, you should see a chart type ā€˜gaugeā€™. This letā€™s you specify a goal and the ā€˜needleā€™ will point out where you are against this goal. If youā€™re not taken to the custom report builder, youā€™d have to create report from scratch. Let me know if thatā€™s the case and if youā€™d like step by step instructions. Best regards! ---
**Author:** ![msshey](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@msshey](https://community.hubspot.com/u/msshey)\ **Post date:** [October 8, 2024, 4:37pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/3 "2024-10-08T16:37:11Z")
Hi Karsten, Thanks so much for the response, step by step instructions would be extremely helpful please. ---
**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:** [October 8, 2024, 4:41pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/4 "2024-10-08T16:41:27Z")
[@msshey\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/838055) what exactly do you see when you click through to the report editor (customise), can you share a screenshot please? ---
**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:** [October 8, 2024, 4:55pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/5 "2024-10-08T16:55:02Z")
[@msshey\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/838055) hereā€™s how youā€™d start from scratch: 1. Create a custom report with the primary data source deals (Menu \> Reporting \> Create report \> Custom report builder \> Choose my own data sources \> Primary data source: Deals \> Next) 2. Select the gauge chart type 3. Drag and drop ā€œAmount in company currencyā€ into the Value area ![karstenkoehler_0-1728406390921.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/7/67abd1b310ca1d35750b2f957e033058a15a4f78.png) 1. Under chart settings, specify the Max (your yearly goal), and, if youā€™d like bands ![karstenkoehler_1-1728406421214.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/8/8b7d64d9e8acf1bfb8bf37b2e06af663b6ec0128.png) 1. Under filters, specify that the deal close date should be this year and that deals must be closed won ![karstenkoehler_2-1728406473893.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/0/00896f95f6315ba680694cf8c8494e111eff5097.png) Let me know if you have any follow-up questions! ---
**Author:** ![msshey](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@msshey](https://community.hubspot.com/u/msshey)\ **Post date:** [October 8, 2024, 6:08pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/6 "2024-10-08T18:08:27Z")
Hi Karsten! This is amazing! Iā€™ve been working on this by myself, and your instructions made it a breeze! Thank you so much! I made a few tweaks since they only want to see the Closed deal amount now. Is there a way to display the percentage towards that goal? For example, if weā€™ve made $101,000, that would show as 10% of our million-dollar target. ![Screenshot 2024-10-09 at 2.04.46 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/4/49778d002bc190cafb1bf488cdb3effd34371b4d.png) ---
**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:** [October 8, 2024, 6:56pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/7 "2024-10-08T18:56:20Z")
[@msshey\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/838055) glad I can help šŸ™‚ % are not an option in the gauge chart type, no. This would be better tracked through sales goals which show percentages: [Create sales goals](https://knowledge.hubspot.com/reports/create-sales-goals) If my replies helped you, please mark them as accepted solutions, Iā€™d really appreciate it. Iā€™ll of course continue replying. ---
**Author:** ![msshey](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@msshey](https://community.hubspot.com/u/msshey)\ **Post date:** [October 8, 2024, 8:55pm UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/8 "2024-10-08T20:55:45Z")
Thanks so much, Karsten! Weā€™ll definitely follow your lead and set up sales goals for better tracking! I have another questionā€”Iā€™ve created a report that shows the monthly revenue breakdown. We want to clearly see how much revenue was generated each month so we can track our progress and compare year-over-year. However, when I toggle the revenue goal, it only shows $0. The goals of this report is to: 1. Provide a clear breakdown of revenue generated from our deals each month. 2. Show how much revenue has been generated compared to our overall goal. Currently, the revenue goal of $0 is inaccurate, and Iā€™d like to set the correct amount. This way, we can quickly see how much was generated this month versus last month to track our progress. ![Screenshot 2024-10-09 at 4.46.37 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/5/e5c16d32e741981202bd5a67d45a9c00ee72d1fa.png) Anothing thing, I canā€™t figure out how to rename the report for this one šŸ˜ž Thanks again and apologies im throwing so many questions! ---
**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:** [October 9, 2024, 4:20am UTC](https://community.hubspot.com/t/average-deal-size-visualization/117906/9 "2024-10-09T04:20:12Z")
[@msshey\_](https://community.hubspot.com/t5/user/viewprofilepage/user-id/838055) of course, happy to help! Out of the box, unfortunately, HubSpot reports arenā€™t good at monthly revenue reporting ā€“ unless youā€™re already creating one deal per month per subscription. If thatā€™s not the case, recurring revenue reporting is (natively) currently only possible through a Sales or Service Hub Enterprise subscription and by following these steps: [Track recurring revenue in HubSpot](https://knowledge.hubspot.com/deals/track-recurring-revenue-with-revenue-analytics) Best regards!