Dashboards & Reporting

NParshotam
Contributeur

Click through records in reports

As a report user, I would like to click on a record to take me to that specific record (deal, contact, etc) so I can review or edit the data. 

 

Right now, records are displayed in a report but there is no way to click into the record to find more details on the specific row.

13 Réponses
mortenstaal
Participant | Partenaire solutions Platinum
Participant | Partenaire solutions Platinum

Click through records in reports

This issue needs to be adressed as soon as possible. It often defeats the purpose of the report building, advantaging the Single Object Report Builder over the Custom Report Builder.

ArdenM
Contributeur

Click through records in reports

Have you tried adding the Record Id as a column or as a field in the fields list? It should add a direct link with both the record's Id and Name to your custom report.

0 Votes
KTotten
Participant

Click through records in reports

This doesn't work. When I try to add Record ID in the data step, it says its "not supported here, try adding as a filter".

I'm using the chart type "unsummarized data table".

0 Votes
ArdenM
Contributeur

Click through records in reports

Unsummarized data table is only an option on the Single Object report builder, while the comment I replied to was about the Custom Report Builder - if you're using the Single Object report builder, you should end up with a clickable record id field by default - it'll be the field with the object name as the column header.

NParshotam
Contributeur

Click through records in reports

Attached is a screenshot. 

 

I'd like to have a report that doesn't show the Customize and Cancel buttons at the bottom ( might be a different idea I proposed), and have the parameters on the left of the table removed. 

 

In addition, if I click on a record, I'd like to be taken to that record.

 

Hope this clarifies things.

 

 

Screen Shot 2022-05-23 at 12.16.05 PM.png

0 Votes
ArdenM
Contributeur

Click through records in reports

Hey!

Not sure if you ever found a solution to this, but if you add the record id as a column on the report it'll show up as a clickable link with the name of the record and the id as well.

0 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Click through records in reports

Hi @NParshotam,

 

This is already a detailed view of the report. Once placed on a dashboard, you will not see the left sidebar. Also, if you click into anything that's highlighted in blue, HubSpot should take you to the corresponding records – can you please try?

 

The user interface you're looking at cannot be customized.

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

NParshotam
Contributeur

Click through records in reports

You're right. Sadly, only the amounts are clickable and that then opens a
pop-up box that shows the deal that's then clickable. One click too many.
0 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Click through records in reports

Hi @NParshotam,

 

Is this created in the Custom Report Builder? If you use the classic report builder (Single object > Deal), then the Deal name column is clickable and will take you to the record directly.

 

You can request that this is changed for the Custom Report Builder in the HubSpot Ideas section of the community. The product team reviews these requests based on popularity.

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

NParshotam
Contributeur

Click through records in reports

Thanks for the suggestion. I tried that but the report now doesn't sum the
amount in company currency column.
0 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Click through records in reports

Hi @NParshotam,

 

In the majority of reports, this is possible. Clicking into any data point (slice of a pie chart, bar in a bar chart etc) will open a table of the contact data behind this slice, bar etc.

 

Which report exactly are you referring to?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

NParshotam
Contributeur

Click through records in reports

A table report - I have tried but clicking doesn't work.
0 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Click through records in reports

Hi @NParshotam,

 

Table visualizations are usually clickable. What exactly is your report showing, could you share more details or even a screenshot?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.