Tableau Tutorial 77 - Tableau Parameters 13 - Dynamic Date Aggregation using Parameters

[@samyukthak.a.5447]

DATETRUNC does not accept parameter directly( atleast in the latest versions), it needs a Case statement to work.
CASE [Dynamic date]
WHEN 'Days' THEN DATETRUNC('day', [OrderDate])
WHEN 'Quarterly' THEN DATETRUNC('quarter',[OrderDate])
WHEN 'Monthly' THEN DATETRUNC('month',[OrderDate])
END

[@damasusaditama2148]

Thank you!

[@rajamani2689]

parameter will work in datetrunc . for that u need to give exact date part of day, week, month, year in parameter list to make it possible.

[@kumarraj2012]

Thanks.. this was very useful..👍

[@shivaraajsm2146]

Hi would like to know can we add start date and end date and further drill down using year Month Day

[@ajaykumarvelivela9472]

Thanks for the video bro

[@aqsaarain5376]

Sir what formula u have written in calculated field?

[@jithenderdommati2827]

Hi Abhishek! I would like to know limitations of parameters.

[@vishwas22khare]

Why did you change to discreat and what date truncated does ,also explain .

[@bhagyashrichaudhari4727]

flexi order date how you created?

[@shwetaupadhyay5421]

Hi Abhishek - How do I make the Labels dynamic too, like it shows Q1, Q2..if Quarter is selected and jan, Feb, Mar...if month is selected?

[@adityacaroli2375]

Hi, were you able to figure out how?