6 Replies Latest reply on Feb 1, 2019 5:44 AM by m ovess

Split dimension values as per another dimension values

m ovess Feb 1, 2019 4:37 AM

Hi,

Need help , I have data source like below

Firm Type Turnover Market

ABC Fin 120 APC

XYZ MKT 205 APC

TUV HR 104 APC

from above data source,

suppose firm ABC want to compare its turnover to other firm , Is there anyway to get the below type of output in tableau.

Market My_Firm MY_Turnover Competitor_Firm Competitor Turnover

APC ABC 120 XYZ 205

TUV 104

Thanks.

1. Re: Split dimension values as per another dimension values

Zhouyi Zhang Feb 1, 2019 4:47 AM (in response to m ovess)
Hi, Ovess

Please find my solution attached

basically, you need join your data to itself using the key firm <> firm(sheet11) as shown below

Here is the result

Hope this helps

ZZ

Book2_v10.2.twbx 10.3 KB
Like Show 0 Likes(0)

Actions
2. Re: Split dimension values as per another dimension values

m ovess Feb 1, 2019 4:54 AM (in response to Zhouyi Zhang)

Thanks for looking inot this.
i tried to do join but datasize is over 60M so it's taking lot of time for extraction. is there any way in tableau.
Like Show 0 Likes(0)

Actions
3. Re: Split dimension values as per another dimension values

Zhouyi Zhang Feb 1, 2019 5:01 AM (in response to m ovess)

what about dashbaord? create two worksheets and interactive by selecting one and change the other?
something like this?

ZZ
Like Show 0 Likes(0)

Actions
4. Re: Split dimension values as per another dimension values

m ovess Feb 1, 2019 5:19 AM (in response to Zhouyi Zhang)

i am trying to create field like MY_Firm and Comp_firm
My_Firm
if firm='ABC' then firm end

Comp_Firm
if firm!='ABC' then firm end

but when i am putting it on shelf it's giving null

My_Site       Cmp_Site
ABC              NULL
NULL             XYZ
                      TUV
Like Show 0 Likes(0)

Actions
5. Re: Split dimension values as per another dimension values

Zhouyi Zhang Feb 1, 2019 5:23 AM (in response to m ovess)

you actually can't do it from calculation field as there isn't a relateion ship for each individual firm within the same row, they are very independently.
Like Show 0 Likes(0)

Actions
6. Re: Split dimension values as per another dimension values

m ovess Feb 1, 2019 5:44 AM (in response to Zhouyi Zhang)

when i am trying to use fixed LOD, like
{fixed market : if (if firm!='ABC' then firm END )}
it's requiring aggregation on dimension.
Like Show 0 Likes(0)

Actions