February 5, 2013
Tableau Tip: Embedding dashboards from multiple, disparate workbooks into a single workbook
Here’s the situation:
- You have several people creating their own dashboards in separate workbooks
- Your boss doesn’t want to open all of the dashboards separately
- You need all of these diverse dashboards in a single dashboard
The solution is way easier than you think. It’s simply a matter of using web page objects.
For this example, I’m going to use these three views:
- Geographically based Economic Data: http://public.tableausoftware.com/views/ATUGJune2011/GeoData?:embed=y
- Afghanistan War Logs: http://public.tableausoftware.com/views/AfghanWar/AfghanistanWarLogs?:embed=y
- Top 100 Grossing Movies of All Time: http://public.tableausoftware.com/views/BoxOfficeHits/Top100Movies?:embed=y
Here’s how it’s done:
Step 1 – You have to connect to some kind of data. I typed up two rows in Excel and copy/pasted them into Tableau. Create an extract. You need to do that to publish.
Data as simple as this will work:
Step 2 – Create a new dashboard
Step 3 – Add a web page object to the dashboard. When the Edit URL dialog appears, copy/paste your URL into the box.
You should now see your dashboard inside the dashboard.
Notice also that if you have tabs enabled on the dashboard, you can see all of those tabs in the web page object.
Step 4 – Repeats steps 2 & 3 for each of the views in the other workbooks.
That’s it! Check out how there are tabs for each dashboard you embedded and then there are tabs inside each of those if you’ve enabled them. Cool!