Drill-Down Advice

#1

Hi all,

I’m a novice bordering on moderate user, so please excuse me if I’m missing an obvious answer. I’m trying to design a drill-down interaction from a dashboard to a report while preserving some filters.

Let me try to give as basic an example as I can think of.

Let us assume that I have a database of vehicles which contains the manufacturer, model, colour, and VIN (unique car ID for those who aren’t familiar).
I build a dashboard with a bar chart that shows me the number of cars that I have of each colour where the manufacturer is Toyota (measure = VIN count, row = colour, slicer = manufacturer with a filter on Toyota).
Now I want a drill-down report that shows me the details (all fields) for each car represented in any given bar (so if I click on “Black”, I get a report of all black Toyotas). I create a report with all the required items and parameters, then I build the drill-down interaction. THIS is where I hit the road block - I can only link the clicked item (colour) to the report. There’s nowhere that I can find which will pass the manufacturer filter that exists on the slicer in the dashboard (“Toyota”).

I’m sorry if I’ve explained it poorly, but hopefully someone else out there has encountered this before and can advise.

Right now I’m solving the problem by having a multitude of data cubes and reports (in this example a data cube AND report for each manufacturer), but that’s a nightmare to maintain.

Cheers and thanks in advance!

-Matt

#2

Hi Matt,

You can pass the value of the manufacturer from your base dashboard to your drill-down dashboard using the below steps:

  • Rather than having your metric set and/or data cube by default filtered to “ Manufacturer = Toyota ” you can create a view parameter attach it to your manufacturer slicer and then set the value of this view parameter to “ Toyota ” instead.
  • Then you can add a similar view parameter to the drill-down dashboard as well and connect it to the manufacturer column of the visualization on the drill-down dashboard.
  • Now when you set up your interaction you can pass the value of this manufacturer view parameter from the base dashboard to the drill-down dashboard by “setting up the parameters” in the interaction configuration.

I hope this answers your question. Please feel free to let me know in case you have any queries about this.

#3

Thank you so much! This worked like a charm!