#Tableau

[@SunitaSaketsahu-dt6ux]

Very useful video, most of the videos in youtube only have first part of video where we are able to select different date granularity, but the dynamic change of date format is missing. Thanks for adding that as well. Here's little modification in it(added Week and Quarter, and changed date format to show month as mmm)
if [Date Level] = 'Year' then STR(YEAR([Complaint Contact Date]))
elseif [Date Level] = 'Quarter' then 'Q' + str(QUARTER([Complaint Contact Date])) + ' ' + STR(YEAR([Complaint Contact Date]))
elseif [Date Level]= 'Month' then left(DATENAME('month',[Complaint Contact Date]),3)+' '+ right(STR(YEAR([Complaint Contact Date])),2)
elseif [Date Level] = 'Week' THEN STR(DAY(DATETRUNC('week', [Complaint Contact Date]))) + ' ' + LEFT(DATENAME('month', DATETRUNC('week', [Complaint Contact Date])), 3) + ' ' + RIGHT(STR(YEAR(DATETRUNC('week', [Complaint Contact Date]))), 2)
elseif [Date Level] ='Day' then str(DAY([Complaint Contact Date])) + ' ' + left(datename('month',[Complaint Contact Date]),3) + ' ' + right(STR(YEAR([Complaint Contact Date])),2)
END

[@NyxView]

Useful video where we play with Data in the Tableau!!
I have a scenario like Most Recent manager should come first for the respective staff.
Example: For Each Staff, multiple Managers are tagged. But the client wants For Each Staff member, Most Recent Manager should come first then rest of
Managers will follow the same.

[@TableauTutor]

Hi Prasad, what is the issue you are facing?
contact me: [e-mail]

[@equiwave80]

Thanks for this video.
I was able to add QUARTER in the Data Level Parameter
I used the below formula for QUARTER in the Order Date (Method 2) Calculated Field.
[Date Level] = 'Quarter' THEN 'Q'+ STR(QUARTER([Order Date])) + ', ' + STR(YEAR([Order Date]))
I wanted to know if it was possible to have HALF YEARLY in the Date Level Parameter
In this case what is the formula that is to be used in the Order Date (Method 2)
Please help if possible.

[@venkatc1323]

👆👍👌👌

[@TableauTutor]

Thank you

[@AshwinKumar75]

Did you notice that all the "april" months across all years are grouped together ? same goes for a date. When you create labels this way, the chronological order of the date is lost. I created this very same solution in a project of mine, but also resolved the chronological issue. Please correct your video by fixing the chronological issue, because without that, the timeline is completely lost.

[@nadeemraja655]

I agree. Please correct chronological order. THX

[@tonyliao6781]

Right-click the string pill in the view to 'Sort > by Field > [Order Date] (original date field) > min/max aggregation' to apply a 'date' sort.

[@panic_seller]

chart is dynamic but the axis is not, like year shows 1/1/2020, month shows 1/1/2020, day shows the same thing just different spacing