3 Replies Latest reply on Feb 9, 2017 10:56 AM by Amy Lambert

    Merge two dashboards

    Hunny Gupta

      Hi,

      I have created two different tableau dashboards on two different data sources. Now I need to merge these two dashboards into one and show both dashboards as tabs. I don't want to recreate all workbooks and dashboard again. Is there a way I can import a dashboard into other? Thanks in advance.

        • 1. Re: Merge two dashboards
          Jim Wahl

          If you're using Tableau Server, you could embed each dashboard as a Web Page object in a new dashboard. See

          http://vizwiz.blogspot.com/2013/02/tableau-tip-embedding-dashboards-from.html

          • 2. Re: Merge two dashboards
            Joshua Milligan

            Hunny,

             

            If I'm understanding correctly, your two dashboards are in separate workbooks?

             

            You can copy worksheets from one workbook to another (see http://kb.tableausoftware.com/articles/knowledgebase/bookmark-copy-sheet)  Unfortunately, this doesn't apply to dashboards.

             

            If you are really ambitious, you could try the following:

            1. Copy all the views you need using the above method.

            2. Make a backup of the workbook you want to get the second dashboard into.

            3. Open both workbooks in a text viewer.  Make sure you've saved them as unpackaged workbooks .twb.  The .twb files are XML.  (Packaged workbook files -- twbx -- are zip files that contain the twb and any data extracts, image files, etc...)

            4. Locate the section in XML that contains the dashboard you want.  Copy and paste that section into the other file.

             

            It might take a little trial and error and I would definitely recommend having backups.  Hope that helps!

             

            Joshua

            • 3. Re: Merge two dashboards
              Amy Lambert

              Hi Joshua,

               

              I have a question that is very similar to Hunny's, so I thought I might just piggy back off of your explanation to get further clarity on my question. I hope that is okay etiquette.

               

              I am doing a little discovery to see if I can merge multiple existing workbooks into one workbook. It sounds like I could copy the the worksheets from each into one new workbook, but then I would have to re-create the dashboards. There is also a recurring issue with both of your methods in my case in that I will need to refresh the data in my new 'combined' workbook each month - it seems like this may not be possible.

               

              Thanks!

              Amy