![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |