Tips & Tricks: Defining Drill-In Attributes

A popular GoodData feature is the ability to breakdown summarized data into smaller parts. This is referred to as a Drill-In. Not only does it enable you to break your data down to a lower level of detail, it also adds interactivity to your on-demand reports and dashboards.

In this example, we’ll show you how to obtain a granular look into the total number of support tickets created. These are powerful metrics for companies looking to measure the level of productivity of a help desk group.

Step One: Starting on the report creation page, click “Show Configuration” which is located on the top right hand side of the report. Here is where you’ll be able to make changes to the chart configuration.

Step Two: To set the drill path, click the “Drill In Settings” link.

Step Three: Click “Add Drill Step” and from the drop down list, select the attribute. Click “Select.”

Once the drill path is defined, the bars in the chart are now clickable. As mentioned earlier, the bars in the chart represent the number of tickets created on a monthly basis and then by clicking on the individual bars, a breakdown of the number of tickets by Group will be revealed.

In this sample, by clicking on the bar representing the number of tickets for the month of August, a new chart is rendered showing the total number of support tickets created by Group for the entire month. Additionally, by clicking on the date label, the chart gets broken down by week. And one click further shows a breakdown of days.

Here is your homework assignment: which Group within your support organization was the most productive in August? The answer to this question is just a few clicks away when using GoodData.