3 Replies Latest reply on Jan 9, 2017 7:40 PM by Chris McClellan

Match up Last Year Dates to this Year

Greg Mooney Jan 9, 2017 7:18 PM

Hi,

I have 2 files. One with date for 2015 broken out with Order dates and one with 2016 with Order dates.

I have dumped both of these data files into Tableau and would like to create some reports/charts showing both time frames in the same sheet.

For now I can show a 52 week trend sheet for the current year (2016) and then one for 2015. But I would like to see both of these charted overlaid on each other but with the Order dates being different I need help.

The Order date format is pretty straight forward.

1/2/2016

etc....

Any help?

1. Re: Match up Last Year Dates to this Year

Chris McClellan Jan 9, 2017 7:34 PM (in response to Greg Mooney)

As long as Tableau is seeing your date as a real date it should be as easy as putting the discrete year on Color and the discrete month on Column and that will work.

The trick is when the data (years) are in 2 files. Are you UNIONing the 2 files together (ie they are the same format, number of columns, etc.. just have different years).
Like Show 0 Likes(0)

Actions
2. Re: Match up Last Year Dates to this Year

Greg Mooney Jan 9, 2017 7:38 PM (in response to Chris McClellan)

Hi Chris,

Right now these are in 2 files. And I don't believe I have anything Joined as I wasn't sure what to join on. Should I combine both files into one?

Sent from my iPhone
Like Show 0 Likes(0)

Actions
3. Re: Match up Last Year Dates to this Year

Chris McClellan Jan 9, 2017 7:40 PM (in response to Greg Mooney)

Yes, I'd definitely combine them Tableau can do this for you using the UNION if they are same/similar enough format or do it manually
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Match up Last Year Dates to this Year

1. Re: Match up Last Year Dates to this Year

2. Re: Match up Last Year Dates to this Year

3. Re: Match up Last Year Dates to this Year

Actions

More Like This