12 Replies Latest reply on Oct 4, 2017 12:04 AM by ankit.ravi

Ratio between 2 rows from the same dimension using the same measure

ankit.ravi Oct 4, 2017 12:03 AM

I want to find ratio between 2 rows from the same dimension. I have attached a sample workbook below. I tried using if else to get this but was unsuccessful in achieving the goal.

In my case I have many unique rows and would like to have a way where I can look at the ratio and difference between 2 unique rows.

Please do let me know if I need to provide any additional information to solve the problem.

Thanks in advance.

Book1.xlsx 9.2 KB
Capture.PNG 23.7 KB
Demo.twbx 8.7 KB

1. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Shinichiro Murakami Oct 3, 2017 5:43 PM (in response to ankit.ravi)

Hi Ankit

I'm sorry I don't udnerstand the request.
Could you clarify the expected formula and results with using real calculation with sample data?

In my case I have many unique rows and would like to have a way where I can look at the ratio and difference between 2 unique rows.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
2. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

ankit.ravi Oct 3, 2017 5:48 PM (in response to Shinichiro Murakami)

Sure, For example in my case I have a dimension which has many unique rows/fields like A,B,C,D,E,F,G and so on.. I am want to find the ratio and difference between any two rows based on some requirements. In the sample data I have A and B from the dimension.

I hope this helps.
Like Show 0 Likes(0)

Actions
3. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Shinichiro Murakami Oct 3, 2017 6:38 PM (in response to ankit.ravi)

I still don't understand.
Provide me with exact calculation you need using sample data.

2/20
3/30
4/40

or

20/30
40/30

Which ratio do you need and which comparison are you talking about?

Shin
Like Show 0 Likes(0)

Actions
4. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

ankit.ravi Oct 3, 2017 6:41 PM (in response to Shinichiro Murakami)

2/20. A quick question, will the approach be any different if it's 20/2?

On Oct 3, 2017 18:38, "Shinichiro Murakami" <tableaucommunity@tableau.com>
Like Show 0 Likes(0)

Actions
5. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Shinichiro Murakami Oct 3, 2017 6:46 PM (in response to ankit.ravi)

GIVE ME EXACT CALCULATION AND EXPECTED RESULT PLEASE.

SHIN
Like Show 0 Likes(0)

Actions
6. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

ankit.ravi Oct 3, 2017 6:48 PM (in response to Shinichiro Murakami)

2/20=0.1

On Oct 3, 2017 18:46, "Shinichiro Murakami" <tableaucommunity@tableau.com>
Like Show 0 Likes(0)

Actions
7. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

ankit.ravi Oct 3, 2017 6:48 PM (in response to Shinichiro Murakami)

I hope you got it.

On Oct 3, 2017 18:46, "Shinichiro Murakami" <tableaucommunity@tableau.com>
Like Show 0 Likes(0)

Actions
8. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Shinichiro Murakami Oct 3, 2017 6:51 PM (in response to ankit.ravi)

Ankit,

I am sorry.
I gave up this communication..

Thanks,
Shin
Like Show 0 Likes(0)

Actions
9. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

ankit.ravi Oct 3, 2017 11:23 PM (in response to Shinichiro Murakami)

Hey Shin, I am sorry for the misinformation. I gave you all the info. I have also attached an excel sheet with o/p that I desire to have. I hope that will help.

Again sorry for the lack of information.

Thanks
Like Show 0 Likes(0)

Actions
10. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Vivek Nayagam Oct 4, 2017 12:00 AM (in response to ankit.ravi)
Hi Ankit,

Check the attached TWBX file and see if it meets your requirement.

Other option is to un-pivot the data set to have Dim A and B as separate columns.

Thanks,
Vivek

Demo (1).twbx 10.8 KB
Like Show 0 Likes(0)

Actions
11. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

Shinichiro Murakami Oct 4, 2017 12:01 AM (in response to ankit.ravi)

would like to have a way where I can look at the ratio and difference between 2 unique rows.

Please explain this statement with the expected formula and real value result with using you sample number.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
12. Re: Ratio between 2 rows from the same dimension using the same measure

ankit.ravi Oct 4, 2017 12:04 AM (in response to Shinichiro Murakami)

Changed me question. Don't need the difference part. I just want to compare how what ratio of 1 row is the other.
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

Ratio between 2 rows from the same dimension using the same measure

1. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

2. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

3. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

4. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

5. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

6. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

7. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

8. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

9. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

10. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

11. Re: Ratio, Difference between 2 rows from the same dimension using the same measure

12. Re: Ratio between 2 rows from the same dimension using the same measure

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account