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

Actions

More Like This