The AHC Analytics Tool: Data Drill-Down Functionality

This guide explains how to use the drill-down functionality in the AHC Analytics Tool. By following the steps provided, users can easily navigate through different charts and tables to obtain more detailed information about specific data values. This feature allows for a deeper analysis of the data and helps users gain valuable insights.

Mark Baker
19 steps
3 minutes

Some charts throughout The Analytics Tool allow you to click a value on a chart in order to obtain additional information about the data that makes up that value. The following steps provide an example of how this drill-down functionality can be used.

Navigate to [https://ahcanalytics.com/](https://ahcanalytics.com/)

Drilling into Categories

For this example, we will select the "Medical Summary - Chronicity Analysis" dashboard from the Demo Client.

To view additional data, we can click the name of one of the chronic conditions that is displayed on the "Primary Chronic Conditions Ranked By Expenditures" chart.

If you see an ellipsis (i.e., three dots "…") next to a category name on a chart, you can tell more information is available about that value.

A drop-down menu will appear, from which you can select options such as "by Diagnosis Description" or "by Procedure Description". For this example, we will select "by Diagnosis Description"

Any of the options listed under "Drill into DIABETES" will let you view additional data about that category. The options listed under "Dashboards" will redirect you to the selected dashboard, where "DIABETES" will be applied as a filter (if this filtering capability is available for that dashboard).

The Analytics Tool will display a chart representing the data that is included within the "Diabetes" chronic condition.

To view the data in a more user-friendly format, click the "Table" option.

The Analytics Tool will change the display to a table format.

You can see what filters were applied to the data by clicking the down arrow next to the count of filters.

Any filters that were applied on the dashboard will be reflected here. The data displayed in this table is limited by those filters.

To close the drill-down display, click the "X" in the top-right corner of the display.

Drilling into Dates

You can also drill into dates on charts. For example, from the "Medical & Pharma Summary" dashboard, we can select a year on the "Medical - Total $, Mean $, & N" chart.

The system will display a list of available drill options. For this example, we will select "by Reporting Month"

The system will open a pop-up window with a chart that displays the monthly data for 2023.

If you hover your mouse over one of the bars, The Analytics Tool will display information about that value.

You can also click one of the bars in order to see additional drill-down options.

If you choose "Show All $100,752", the system will display a table containing various data fields related to the $100,752 in claims that occurred in May 2023.

If you select "By Reporting Raw" instead, you will see a chart displaying the raw data for each Service Date that occurred in May 2023.

You can also change the data to a table format by clicking "Table"

This will display the data in table format.

The AHC Analytics Tool: Data Drill-Down Functionality

Mark Baker
19 steps
3 minutes