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
2,728 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 10, 2018 in Tableau by ffdfd
• 5,550 points
1,555 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 13, 2018 in Tableau by xyz
• 1,560 points
7,249 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,820 points

edited Sep 21, 2021 by Soumya 660 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
11,734 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 8, 2018 in Tableau by Nitish
• 630 points
1,016 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 10, 2018 in Tableau by Atul
• 10,240 points
1,508 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, 2019 in Tableau by Cherukuri
• 33,030 points
748 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, 2019 in Tableau by Cherukuri
• 33,030 points
17,171 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
2,055 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
1,656 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP