Using any kind of URL will only work if you have single params to pick from (or max/min dates to pass). 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. In my case we were trying to do this with a 300,000 row download. So the last thing we want is to tax the vizSQL engine with rendering all that data.
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. Ensure filters are global or applied to this worksheet from your "driver" worksheet.ģ.Ĭreate a worksheet with the data you want on Details. Choose Mark Type "Shape" and select one you like - I chose a circle.Ĥ. Make the Shape bigger and squish the screen down to show just a few.ĥ. 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".Ħ. Go to your dashboard and drag the worksheet on whereever you want.ħ. The user will have to click in the circle to "Highlight" it and then do the export.įor more fun: Since you are embedding a live worksheet on your dashboard it will take extra time to process. Get around this by adding a Boolean filter that the user can checkmark with a title such as "Fetch Details for export".
The circle will disappear when this is false and reappear when it is true. Oh my gosh - it almost looks like workflow. Except it's ugly!Įnjoyed reading through this blog concerning converting a viz to csv file (over three years of comments!!) A number of comments noted they wanted the csv to be dynamically filtered on the dashboard – manually completed adding the suffix: ?&dim1=wantedvalue at the end of the URL. Perhaps the below method for dynamically filtering a view/csv by dimension(s) which might work - listed below:ġ. When publishing the dashboard also publish the wanted viz/csv separately from the dashboard.Ī. Copy the html path of the viz from the share menu listing the web path on the tableau web page.Ģ.
At the Tableau Desktop create a view with wanted dimension(s) – creates distinct list of values.ģ. Paste/Inserted a calculated field with the http path link to the viz web page published separately in quotes: e.g.: and append the wanted dimensionī. Set the mark to shape: excel icon (import icon to shape directory )Ĭ.
0 kommentar(er)
