Since you are publishing the workbook to Tableau Server, you could use URL filtering when viewing the workbook, to set the filter to the latest quarter.
Here is an article on how to do that:http://kb.tableausoftware.com/articles/knowledgebase/view-filters-url
Thanks..Jonathan for the reply.
Actually I want to find out the current fiscal quarter using today() function.It should be in the format yyyyqq.Then I will compare with existing field fiscal quarter to filter it for latest fiscal quarter.
Have you ever tried something like this.Any help will be appreciated.
I think this might be what you are looking for.
I created a second parameter to use integers instead of strings. This makes creating other calculations easier and in big data sets will help with response time.
Second I created a calculation that checks the parameter and the filter vs. the current quarter and year in the format specified.
If the parameter is set to Latest Fiscal Quarter and the Fiscal Quarter Filter is = to today (using the format you specified) then it will display the data.
If the parameter is set to Anchor Fiscal Quarter than the user can use the Fiscal Quarter filter.
The one thing I couldn't do was make the user unable to change the filter when the parameter is set to Latest Fiscal Quarter. What it does is not show the data if they select anything other than the latest fiscal quarter.
Hope this helps,
Latest fiscal Quarter.zip 15.5 KB
Thanks again Jonathan..
I saw that you have created one calculated field where you have used today() to find out the fiscal quarter.Here the challenge is that actual fiscal year starts from august and when we use today() we are getting the wrong fiscal quarter .because tableau is considering fiscal quarter starts from january.Is there any way we can find out the fiscal quarter using today() where fiscal year starts from the month August.