Tableau Dynamic Parameter for Selecting Most Current Date or Default Value

Learn how to set the most current date in your tableau report or dashboard using dynamic parameters tableau functionally which helps automatically update the parameter value as well as keep track of the most current value or date based on the calculated field specified.
Search all my videos here in this interactive report - datastudio.google.com/u/0/rep...
200+ Tableau tutorial vides - • Tableau Tutorial 1 | H...
List of the all the tableau dashboard tutorials projects - • Tableau Data Science P...
Tableau Prep Builder Tutorial - • Introduction of Tablea...

[@saikishore2401]

Hope your videos will help me to make my self comfortable in Tableau.
I'm a Qlik developer till date.. Who is going to work with Tableau from now as a part of migration.

[@NyxView]

Useful Information Abhishek. Keep posted the scenarios like this

[@shreyachand1313]

Thanks Abhishek...it was really helpful

[@arifsheikh2163]

Thanks Abhishek , It helps .:)

[@selmkt-yoonjaeyoung454]

THX for your information. This is what I was looking for!! One small Question. Could you let me know why we need to use FIXED LOD for 'Latest date'? If I use MAX(DATE), it also works.

[@jorgeramos7348]

Hi Abhishek, nice video!!! If you choose another date in your parameter, will you see the amount of the new date or you will see always the amount of the last update?
Regards!!!

[@rosinetempest2133]

Please how do you use this dynamic parameter with a "Range" and set it to default to a specific Quarter? Giving you a Range Date instead of Relative Date

[@xinranji775]

Hi Abhishek, thanks for the tip.I got one question, how to I set default value to current month if current month is not the lastest month in the data? Best.

[@1maddinenisandeep]

Max(date)

[@karthicks984]

Hi Abhishek,.. Good video.. Thank you so much.. I have question.. I want to filter data in backend before tableau bring it to view.. will that be possible with parameter?
Please guide me..

[@AbhishekAgarrwal]

Yeah it should be doable using custom sql query and there you can pass the parameters.

[@karthicks984]

@@AbhishekAgarrwal Thank you for your reply.. Can we do without custom SQL? The thing is user can add any new field from datasource at any time.

[@AbhishekAgarrwal]

@@karthicks984 in my view it can't be done. You need to have all the columns present in the tableau to provide this flexibility.

[@karthicks984]

@@AbhishekAgarrwal ok thank you... One quick question.. if I add filters in datasource page, will restrict data in backend database itself or will it bring all data & then restrict in tableau view?

[@AbhishekAgarrwal]

@@karthicks984 in that case it will restrict the data and it won't come in tableau for use.