Advanced: Add cascading drop-downs

With cascading drop-downs, the option you select in one drop-down narrows the options available for another drop-down. The two filters that these drop-downs are built on must have a logical or defined relationship in the Data Library: for example, Team to Agent.

EXAMPLE   You’ve followed the steps in the Basic section and created a drop-down that lets you see average evaluation scores by team. Add a cascading drop-down so that you can see average scores for a single agent on that team.

Step 1: Add filters if necessary

If your report already has all the filters you need, you can skip this section.

EXAMPLE   

For this example to work, we need to add another filter to the Average Evaluation Score report that the Sample Home Page for a QM Supervisor guide helps you build. This filter lets you see scores by agent.

  1. Click the report (in the Reports list).
  2. In the Question panel on the right side of the page, under Filters, click [limit].... The Select Filter window opens.
  3. In the Name column, click Agent.
  4. In the Field column, click Agent Full Name.
  5. Click Add. The Select Filter window closes, and Agent Name appears as a filter on your report.

Step 2: Name the second filter as a report parameter

Follow Step 1 from the Basic section to name the second filter as a report parameter.

EXAMPLE   Give the Agent filter the parameter name “AgentName.”


Step 3: Add another drop-down panel to the dashboard

Follow Step 2 from the Basic section to add a second empty panel to the dashboard.

EXAMPLE   Add another compact member picker panel and title it “Select an Agent.” Here, you will select agent names after filtering the report by team. Your dashboard now looks like this:

Step 4: Connect the second drop-down to the report and to the first drop-down

This connection tells Data Explorer how the two drop-downs work with each other and with the report.

BEST PRACTICE   Before you start this step, make sure you know which drop-down will be first (or the “parent,” the one you’ll use first in the filtering process) and which drop-down will be second (or the “child,” the one you’ll use second).

EXAMPLE   You want to filter evaluation scores by team and then by agent. Team is your first drop-down, and agent is your second drop-down.

  1. Click Parameters (upper left of the screen). The Parameter Bindings window opens, showing the drop-down you connected from the Basic section.
  2. Click Add a new Parameter (the + icon). Parameter fields appear.
  3. (Optional) Enter the name of the second drop-down in the Parameter field.

    EXAMPLE   As the second step in the filtering process, you will select agent names. Enter “agent” in the Parameter field.

  4. Make sure that text list is selected from the Type list. (If you’re creating a time-period selector, select time periods.)
  5. Select the second filter’s name from the Bindings list.
  6. Click the + icon next to the Bindings list. An additional list appears.
  7. Select the second drop-down’s title from the list.
  8. Go back to the first drop-down that you created in the Basic section, and click the + icon next to the second list. A third list appears.
  9. Select ‘filter’ on “[the second drop-down’s title]” from the third list. This step connects the first and second drop-downs to each other.

    EXAMPLE   Our parameter bindings now look like this:

  10. Click Apply. The Parameter Bindings window closes.

    NOTE   If you open the Parameter Bindings window again, the parameters will switch order, with agent on top of team. Don’t worry, they still work the way they did before.

  1. Click Save. Congratulations, you’ve added cascading drop-downs to your report!

    EXAMPLE   

    Our dashboard now looks like this, with average evaluation scores visible by team and then by agent. Select a team, and then select one or more agents to see scores for those agents.

Keep learning about Data Explorer

Our Data Explorer library has a great collection of guides for people who are new to Data Explorer or are looking to grow their skills. Check them out!