Drill-downs

Wanted to share a feature that exists in most of the player and team reports that can show or hide a lot of information that may not be readily apparent. Consider the below summed by game player report for Yuki Yanagita:

By default, this chart breaks down stats by year and month. What may not be readily apparent is that you can actually alter this to be more or less verbose. To do so you need to simply hover your mouse over the chart and you’ll see some squares popup in the upper-right. These are known as the drill down options.

Each arrow will re-calculate the data in a different way. Consider for example if you click the left-most ‘Up’ arrow:

Whereas before the data was split up by year and then month, we have now removed the month as a metric, so the data is instead shown by just year.

Let’s use another example. Consider the below table that shows Yuki Yanagita’s batting stats against each team in the league:

Here it is a bit more obvious that more information can be shown or hidden using the plus/minus boxes to the left. Here the hierarchy is currently showing stats split by the opposing team and then the year.

Let’s say we only care to see the totals for each team, and we don’t need it again broken out by year as it currently is. You can do this by either clicking on the minus boxes next to each team on the left or, much more easily, clicking the Up arrow in the drill-down:

Now we’re just seeing Yuki Yanagita’s total stats playing against each team in the league.


So, what does each button do?


DRILL UP

Drill up we’ve covered, if you are not already at the top-most level of the hierarchy then it allows you to remove a layer of detail. In the above cases we removed the month layer of detail to see stats broken out by only year, and then the year level of detail was removed to see the total stats by each team Yuki Yanagita played against.

DRILL DOWN

This option is actually a little deceiving. If you click on it nothing will immediately change. Instead, it is waiting for you to select an area of the chart or table in order to determine what to do. When you click the arrow, it will change to:


It is then waiting for you to select something from the current level of the hierarchy and then it will only show you data from the area you clicked. For example, if we click on Chiba Lotte below:

The table will filter to only show the relevant data from Chiba Lotte:

In short, this option is a filter. We could accomplish the same thing as above by filtering to only show Chiba Lotte as the opposing team:


NEXT LEVEL DRILL DOWN

This option will go to the next level in the hierarchy and leave out or ignore the higher level. Consider the below chart once more, currently showing data split up by only the year:


Clicking on the next level drill down will break out the data as such:

Note the X axis label is now only showing months. The data is now being displayed to show how Yuki Yanagita performs on a month-to-month basis, without differentiating by year. His best month throughout his career appears to be July.

We can go even further with this and drill down again:


Now we are showing how he performs by day of the month. This level of detail probably does not make much sense, especially as there’s the possibility that a player has only ever had one game on a particular day of the month in their career, which is why we see such dramatic fluctuations day to day. Still, the functionality is there. In the “Summed by PA” reports I default to showing data on a per-inning basis just to give an idea of the level of detail possible.


EXPAND DOWN

This is probably the most useful option in the drill down. This will expand down to show one additional level of detail (such as going from year to month) while still taking into account the upper level of data. In the “Summed by Game” reports I default the league average chart to do this by showing both year and month:


You can expand on this even more, if we were to click the expand down button once more:


Now, we’re showing data by year, month, and day. Looks quite messy but as a result you can see how a player performed each and every game of their career.

Let’s use another example with the ‘Batting Stats Split by Opposing Team’ report. By default, the report appears as below, showing data split by the opposing team as well as by year. In this chart the hierarchy goes Opposing Team > Year > Month > Day:

Let’s say you wanted to see how he performs against each team each month as well. You could do so by clicking on each and every plus sign on the left, or much more simply by clicking the Expand Down button once more:

As you can tell from the still present plus/minus boxes to the left, if we wanted, we could go another level further and show these same stats split up not just by month but by day as well. In this way you can see one player’s stats each and every day they played a particular team.

And that’s drilldowns. They’re available in many of the reports, especially in the “Summed by Game” and “Summed by PA” reports. For any table, if you see plus/minus boxes to the left, that indicates that drill downs are available. For any chart, simply hover over the chart to see if drilling down is an option.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.