Asking for your assistance. How do I make this 3 Dashboard into 1 Dashboard only?
I tried creating one, the Date entered "LCB (Lead Status)" (the Launch Call Booked) has the accurate data (sort of), while the others have been added on the Y-axis as "distinct count" only.
Been stuck on this for a while 😬 Inputs are much appreciated!!
In HubSpot reports, you can place only one date property on the x-axis – I'm not aware of ways to have the axis display multiple date properties. Your best option would be to place these reports side by side on a dashboard to have all information at a glance.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Another way to combine this data in a dashboard view is by connecting it to a spreadsheet - this gives you the flexibility to manipulate the chart and build a variety of views. I use one called Coefficient which connects seamlessly to HubSpot and allows you to set an auto-refresh schedule. This way you'll always have the latest update for your data and all your charts connected to this data will automatically update.
The simplest way to solve this would be to get this data on Sheets/Excel so you can utilize their graph functionalities (which allow your 3 dashboards to become one).
There are a bunch of connectors that can get your data on Sheets/Excel. Personally, a big fan of Superjoin.
You can pull in data into spreadsheets, create all the complex visualizations.
You can also use tools like Google Looker Studio or Power BI. They have direct integrations with Hubspot.
In HubSpot reports, you can place only one date property on the x-axis – I'm not aware of ways to have the axis display multiple date properties. Your best option would be to place these reports side by side on a dashboard to have all information at a glance.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer