Can you post an example workbook ad the url you are using?
I have gone through the below community articles, i am able to download the data in .CSV file but it is static , it is not filtering the data dynamically if apply any filters.
Yes...that is a known issue. We have also faced this issue. I couldn't find any solutions for that.
We have given the name of the Excel download as "Raw Data" so that user know that filter doesn't work.
Another option is to ask the user to select "Specific Sheet" and Choose "Crosstab" option in "Download" menu bar.
This way all filter would have been applied.
Thanks mandeep for your response. Yes i am also thinking that the name of the Excel download as "Raw Data" .
Le'ts see any workaround receive? if not will go through this recommendation.
Hi Bayapa (and Mandeep),
You can get the desired results by:
1) Making sure the download button worksheet has all the desired filters applied, whether as a target of filter actions or target of scoped or global filters.
2) Adding the filters to the URL action per these instructions URL Actions.
I set this up in the attached workbook. The URL action is configured as follows:
In this case the complete URL action ends up looking like this:
http://myTableauServer/#/site/mySite/views/tmpdownloadbutton/csvsheet.csv?YEAR(Order%20Date)=<FILTERVALUES(YEAR(Order Date))>&Ship%20Mode=<FILTERVALUES(Ship Mode)>
Also note that the CSV uses the default number formatting of the included fields, so if you want 1234.56 as a number and not "$1,234.56" as a quoted string then you'll need to change the default number formatting of the field to be a number with 2 decimal places and no separators and then in views customize the number formatting for each pill. Or just use different fields for the download vs. the view. For example I might use a field named "Sales" for the download and a duplicate named "Sales " (with a trailing space and currency number formatting) for my views.
v10.3 workbook is attached.
Thank you very much Jonathan for your workaround solution. Trying to derive this. if we face any issues will get back to you.
Once again thank you very much for your great help and workarounds.