Put an instruction Title on such as: "To Export Details, Click on the circle below and then click on Export (icon above) and choose Crosstab".Ħ. Make the Shape bigger and squish the screen down to show just a few.ĥ. Choose Mark Type "Shape" and select one you like - I chose a circle.Ĥ. Ensure filters are global or applied to this worksheet from your "driver" worksheet.ģ. Create a worksheet with the data you want on Details. I think this approach may provide adequate speed although it is sinfully ugly.Īssume you already have a dashboard with some filters (multi-select) etc. So the last thing we want is to tax the vizSQL engine with rendering all that data. In my case we were trying to do this with a 300,000 row download. Since this only covers a small number of use cases, we must get the user to click an embedded worksheet on a dashboard and then use the Tableau standard export. Using any kind of URL will only work if you have single params to pick from (or max/min dates to pass). Opening the workbook will not work since it assumes you are starting a brand new session and so only your default (published) filters and params are available. The ONLY way to get what we want is to have the user click the standard Export - CrossTab built into Tableau server. I had to name it with a capital A so that it would be the first sheet alphabetically on the dashboard. I changed the height to 1 and made everything white and transparent and chose Fit Entire View so that it would be inconspicuous.
Tableau Explorer – $42 USD/user/month billed annually Includes: Tableau Desktop, Tableau Prep Builder, and one Creator license on Tableau Online.Includes: one Viewer license of Tableau Server.įor Teams & Organizations – Tableau Online deployment (fulled hosted by Tableau).