5 Replies Latest reply on Jun 6, 2017 7:33 PM by Zhouyi Zhang

Compare data from prior quarter under the same timeline

Loretta Xia Jun 5, 2017 8:00 PM

Hi friends,

As shown in the picture. I'm trying to compare QoQ data with the same x-axis time range(Jan-Mar) but the previous Quarter data shifts away.

Any method to achieve this?

Thanks all!!

Loretta

1. Re: Compare data from prior quarter under the same timeline

Zhouyi Zhang Jun 6, 2017 12:21 AM (in response to Loretta Xia)

Hi, Loretta

can you provide a sample workbook?

ZZ
Like Show 0 Likes(0)

Actions
2. Re: Compare data from prior quarter under the same timeline

Loretta Xia Jun 6, 2017 2:18 AM (in response to Zhouyi Zhang)
Hi zz,

Thanks for your reply!!
Here you go with some simple data..
lmk if there's anything you need.

Loretta

lastQuarterSales.twbx 12.6 KB
Like Show 0 Likes(0)

Actions
3. Re: Compare data from prior quarter under the same timeline

Zhouyi Zhang Jun 6, 2017 4:45 AM (in response to Loretta Xia)
Hi, Loretta

Is this what you are after?

I attached the workbook for your reference. please let me know if you have question

ZZ

lastQuarterSales.twbx 17.3 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Compare data from prior quarter under the same timeline

Loretta Xia Jun 6, 2017 7:19 PM (in response to Zhouyi Zhang)
Hi zz,

Thank you so much for the great idea!
I made a little change of your code there.. the month doesn't fall in the right place in your code.
Anyways, THANK U!!!!

Loretta

lastQuarterSales (1).twbx 16.9 KB
Like Show 0 Likes(0)

Actions
5. Re: Compare data from prior quarter under the same timeline

Zhouyi Zhang Jun 6, 2017 7:33 PM (in response to Loretta Xia)

no worries. glad it helps you figure out your case.

ZZ
Like Show 0 Likes(0)

Actions

Tableau Community