Chart Drill Through in Winter ’18 Release

The Winter '18 release of Sugar features a significant enhancement to Reports - “Drill Through on Charts”. This capability has been requested by many of our customers and provides significant value to all report users.

Chart Drill Through

 

The drill through features provides the ability to see the data behind the charts in reports. As a user, when you are looking at a report, you want to get more insights to the data. Let’s say you are looking at a pipeline report and you want to see the open opportunities in a specific stage. You should be able to simply click on the relevant section of the chart and see the details. That’s what this feature does.

How does it work?

In order to see the data behind a report, all you have to do is simply click on the relevant section of the chart. After you click, you will see the detailed data. For example, let’s say we have a chart that shows open opportunities by expected close month. You would like to see all the open opportunities for this month. Simply click on the area of the chart for the current month e.g. a vertical bar for the month of January. After clicking, you will see all the opportunities that are expected to close in January. It’s that simple.

Along with the detailed data, the same chart is now available on the right hand side for your convenience. The section you clicked is highlighted on the chart. You can now click on another section of the chart, say next month’s opportunities, and the data will refresh right there. You don’t need to go back to the report or the dashlet.

But wait there’s more. Not only you see the details behind the chart, you can actually take actions. For example, you can edit the data right in the detailed view. You can do all the actions on the data that you might do on your list view. In fact, the detailed data on the chart is actually the same list view, but with only the data relevant to the area of the chart you clicked.

You can edit the data, delete or perform mass actions. Let’s see this in action in this short video.

Where can you find it ?

The drill through feature is available in the following places

  • On a report with a chart
  • On saved report dashlets

The drill through feature is not available for the following -

  • The report’s base module was legacy BWC
  • Mobile app
  • Out of the box dashlets
    • Sales Pipeline Chart
    • Case Summary
    • Opportunity Metrics

Summary

As you can see, with drill through on charts, not only you see the data behind the report, but also are able to take action on the data thus providing significant productivity improvement in managing records (Insights to Actions).

SugarCRM is investing significantly in enhancing the Reporting and Insights capability. The drill through feature is a significant enhancement in providing deeper insights and perform actions.

Explore

PartnerClub

PartnerClub

Dev Club

Engage

Explore

PartnerClub

PartnerClub

Parents
  • Hi Deepak,

    We're really looking forward to upgrading to make the most of this feature (on prem customer).

    It would be great is if it were possible to customise the fields/columns presented to you depending on the dashlet/report drilled from. This would allow us to take the focus the reporting/dashboards bring and highlight the most important data behind.

    Is this something you have looked into/got on your roadmap?

    Thanks

    Andrew

  • Hi Andrew

    This is certainly something we will look into in the future. Currently, the columns in the list presented is the same as the columns in the list view of the module on which the report is based. So if you customize the module's list view, the same would apply to the list presented after the drill through. 

    Thanks for the suggestion. I will put your suggestion as an idea. The ability to customize the list view columns in drill through window. 

    Deepak

Comment
  • Hi Andrew

    This is certainly something we will look into in the future. Currently, the columns in the list presented is the same as the columns in the list view of the module on which the report is based. So if you customize the module's list view, the same would apply to the list presented after the drill through. 

    Thanks for the suggestion. I will put your suggestion as an idea. The ability to customize the list view columns in drill through window. 

    Deepak

Children
No Data