Drill Through Functionality in Looker

| Analytics , Looker ,

Adding drill through feature to your visualizations enable users to look into different layers of data granularity and analyse hierarchical data. In this blog we have explained how you can apply drill through functionality in  Looker.

Step 1:  Login to Looker web and select the data under Explore menu bar.

drill-through-in-looker

Step 2: Once you select the data, the following window will appear.

drill-through-in-looker

Step 3: Select a dimension and measure. In this example, I have chosen “Country” as the dimension and “Count” as the measure. Click on “Run” at upper right corner of the window as shown below.

drill-through-in-looker

Step 4: After running the data, the following window will be displayed.

Step 5: Enable the “Development mode” under Develop menu and select “Manage LookML Project”.

drill-through-in-looker

Step 6 :  Select the required Project model as shown below.

drill-through-in-looker

 

Step 7: After selecting the “model”  a window as shown below will be displayed.

drill-through-in-looker

Step 8: Select the required view.

drill-through-in-looker

Step 9: Change the LookML code for the “Country” dimension.

drill-through-in-looker

After adding the code, save the changes and execute, commit, and deploy the changes in the project.

Step 10: Exit from the development mode

drill-through-in-looker

Step 11: Navigate to the project by selecting “Project” under explore menu as shown in Step 1 and  select the Measure – “Count”and Dimension – “Country” and click on “Run”.

drill-through-in-looker

Step 12: Click on a data point and a tooltip appears as shown below.

drill-through-in-looker

Step 13: Click on the country name and  it will display the drill through value in a drop down as shown below.

drill-through-in-looker

Step 14: Click on the drill through field and a pop up window with data drilled down to state appears as shown below.

drill-through-in-looker

Thus we can drill down to details and analyse hierarchical and granular data points.

Share with:

FacebookTwitterLinkedIn