Can I drill from one dashboard to another?
I'm trying to set up a few dashboards for a client and they want to be able to link from one to another. For example, the data contains a hierarchy, say 1->2. The main dashboard views the data at level 1, and the secondary dashboard views the data at level 2. The reports on the two dashboards contain different measures, so drill through is not an option. I'm wondering if it is possible to be able to click on one of the values of the first dashboard, pass it through to the second dashboard and use it as a filter to view the data at the next level down in the hierarchy?
At the moment I can seem to do is drill down the first dashboard to view it at level B. For example, if the first dashboard has reports at level 1 with measures A, B, and C, and the second dashboard has reports at level 2 with measures D, E, and F, all I can seem to do is drill down to view the first dashboard at level 2 with measures A, B, C. My other option seems to use drill through to link each individual report to other reports. This works but I would ideally like to be able to view all reports together in the dashboard layout rather than one at a time. Is it possible to link a report in a dashboard to another dashboard altogether?