How to merge Year ,Month and date in Order Date in Tableau?

0 votes

I'm struggling to get Year, Month and Date in single column from [Order Date] in Tableau 10.

Could you help me here? I need to drill down [Order Date] to get the dates liked showed in attached Snapshot 1, But I want dates in format showed in attached Snapshot 2. Please refer to the snapshot below.

image

Aug 24, 2018 in Tableau by Naruto
• 710 points
60 views

1 answer to this question.

0 votes
Hi, you can simply drag the Order Date pill by right clicking it and dragging it to the row/column shelf. Then in the drop-down menu that appears you can select the desired format you wish to plot in your analysis. Hope this helps.!
answered Aug 24, 2018 by AwesomeSauce
• 860 points

Related Questions In Tableau

0 votes
1 answer

Is it possible to merge year, month and date in Tableau?

Remove all the date pills and drag ...READ MORE

answered May 9, 2018 in Tableau by Atul
• 5,530 points
20 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
1,402 views
0 votes
1 answer

How should I prepare in order to get Tableau certified?

There are tonnes of video tutorials and ...READ MORE

answered May 10, 2018 in Tableau by QueenBee
• 1,810 points
16 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
1,986 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
35 views
0 votes
1 answer

How can I convert week into Date(mm/dd/yyyy)?

Right click on your date field, you'll ...READ MORE

answered Aug 9, 2018 in Tableau by Atul
• 10,240 points
78 views
0 votes
1 answer

How to get only the last n months action of all my records?

Hi Nithin, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 17,670 points
42 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 17,670 points
196 views
0 votes
1 answer

How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
63 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
37 views