Dashboards & Reporting

DavidBrown
Member

How to create a report with multiple KPI's

SOLVE

I'm looking to create a KPI report showing the count of deals created, the count of deals that entered a specific stage, and the count of deals won this week compared to last week. 

This default report shows the visual I'm looking to create. How do I recreate this with different data?

Screenshot 2023-01-29 at 8.20.29 PM.png

1 Accepted solution
jolle
Solution
Key Advisor | Platinum Partner
Key Advisor | Platinum Partner

How to create a report with multiple KPI's

SOLVE

Hey @DavidBrown, thanks for reaching out!

 

As far as I know, there sadly isn't a way to build reports in a template like the default one you shared.

 

However, you can still absolutely create the reports you're after individually!

  • Deals created — you can do count of deals by deal create date
  • Deals that entered certain stage — you can do count of deals by "Date entered stage: [stage name]"
  • Deals closed won — you can do count of deals by close date or "Date entered stage: closed won"

You should be able to add in the desired time comparison, and you can use the "summary" display option if you just want to see the count of deals:

 

Screen Shot 2023-01-30 at 9.56.42 PM.png

 

I know this isn't perfect, but hopefully it's helpful!!

Jacob Olle

Director of Marketing Technology

NgageContent

HubSpot Certified Trainer

emailAddress
jacob@ngagecontent.com
website
https://ngagecontent.com/
Create Your Own Free Signature

View solution in original post

2 Replies 2
oeniola2
Member

How to create a report with multiple KPI's

SOLVE

Great. I need assistance on report template.

0 Upvotes
jolle
Solution
Key Advisor | Platinum Partner
Key Advisor | Platinum Partner

How to create a report with multiple KPI's

SOLVE

Hey @DavidBrown, thanks for reaching out!

 

As far as I know, there sadly isn't a way to build reports in a template like the default one you shared.

 

However, you can still absolutely create the reports you're after individually!

  • Deals created — you can do count of deals by deal create date
  • Deals that entered certain stage — you can do count of deals by "Date entered stage: [stage name]"
  • Deals closed won — you can do count of deals by close date or "Date entered stage: closed won"

You should be able to add in the desired time comparison, and you can use the "summary" display option if you just want to see the count of deals:

 

Screen Shot 2023-01-30 at 9.56.42 PM.png

 

I know this isn't perfect, but hopefully it's helpful!!

Jacob Olle

Director of Marketing Technology

NgageContent

HubSpot Certified Trainer

emailAddress
jacob@ngagecontent.com
website
https://ngagecontent.com/
Create Your Own Free Signature