2 Replies Latest reply on Feb 11, 2019 9:24 AM by Abin Alex

How to create a single table to compare the different metric values over different periods then show the % change.

Abin Alex Feb 11, 2019 8:25 AM

Hi Guys,

Can you please tell me the best way to create the below table in Tableau?

Measures	Current Period	Previous Period	Current Period -Previous Period	%Change
Impressions
CTR
Clicks
...

I have a Date parameter for the user to select a particular date and then based on that I have created calculations to find the first two columns but stuck in creating the third and fourth column to the same table

Thanks,

Abin

1. Re: How to create a single table to compare the different metric values over different periods then show the % change.

Naveen B Feb 11, 2019 8:35 AM (in response to Abin Alex)

Hi Abin,

Could you please explain in detail what is the period selection and if possible add the sample workbook so that to help you further.

BR,
NB
Like Show 0 Likes(0)

Actions
2. Re: How to create a single table to compare the different metric values over different periods then show the % change.

Abin Alex Feb 11, 2019 9:24 AM (in response to Naveen B)
Thanks for the quick response.

Attached the tableau dashboard and the excel file.

Sample Dataset.xlsx 9.9 KB

Table check.twbx 17.5 KB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to create a single table to compare the different metric values over different periods then show the % change.

1. Re: How to create a single table to compare the different metric values over different periods then show the % change.

2. Re: How to create a single table to compare the different metric values over different periods then show the % change.

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account