-
1. Re: Create a new dimension
Norbert MaijoorJan 23, 2018 1:37 AM (in response to anoosha shetty)
Hi Anoosha,
Find my approach based on UNION as reference below and stored in attached workbook version 10.3 located in the original thread.
1. Define a Union with 3 sheets
1. D1. Type:
if [Table Name]="Sheet1" and [New_existing]="NEW" then "NEW"
elseif [Table Name]="Sheet1" and [New_existing]="Existing" then "EXISTING"
elseif [Table Name]="Sheet1" and [New_existing]="Missing" then "MISSING"
elseif [Table Name]="Sheet1$" and ([New_existing]="Missing" or [New_existing]="Existing" or [New_existing]="NEW") then "TOTAL"
elseif [Table Name]="Sheet11" and ([New_existing]="Existing" or [New_existing]="NEW") then "TOTAL (ex. MISSING)"
END
2. Drag the required objects to the indicated locations and exclude "Null" D1. Type
Regards,
Norbert
-
union_nalmai_10.3.twbx 19.6 KB
-
-
2. Re: Create a new dimension
anoosha shetty Jan 23, 2018 11:04 PM (in response to Norbert Maijoor)Hi Norbert ,
Sorry I am very new to tableau world , and I am using the version. 10.2 ,hence could not open the file you have attached .
I want to mention that in the above question "New_existing " column which I have mentioned is in from the single excel sheet (say called "raw data") , I have pulled it in the datasource field.
I have 2 questions :
1. Are you asking me to do the union of same "Raw data" sheet again ?
2 .
In the above query you have attached :
if [Table Name]="Sheet1" and [New_existing]="NEW" then "NEW"
elseif [Table Name]="Sheet1" and [New_existing]="Existing" then "EXISTING"
elseif [Table Name]="Sheet1" and [New_existing]="Missing" then "MISSING"
elseif [Table Name]="Sheet1$" and ([New_existing]="Missing" or [New_existing]="Existing" or [New_existing]="NEW") then "TOTAL"
elseif [Table Name]="Sheet11" and ([New_existing]="Existing" or [New_existing]="NEW") then "TOTAL (ex. MISSING)"
END
Can you explain me what is [Table Name] ? and what is Sheet1 , Sheet1$ , and Sheet11 ? in my reference .
This will be really helpful
Thanks,
Anoosha
-
3. Re: Create a new dimension
Zhouyi ZhangJan 23, 2018 11:39 PM (in response to anoosha shetty)
Hi, Anoosha
Please see the explain below
and the online help link for your reference.
Hope this helps.
ZZ
-
4. Re: Create a new dimension
anoosha shetty Jan 24, 2018 1:15 AM (in response to Zhouyi Zhang)Hi ZZ ,
Thank you so much for the detailed explanation .This worked like magic .
Happy to learn new stuff everyday like this .
Norbert Maijoor -- thank you so much for the direction you have given .
Thanks all
Regards ,
Anoosha
-
5. Re: Create a new dimension
Norbert MaijoorJan 24, 2018 1:17 AM (in response to anoosha shetty)
Hi Anoosha,
You are welcome. Keep them coming if you have any challenge on you journey in the land of Tableau.
Regards,
Norbert
-
6. Re: Create a new dimension
anoosha shetty Jan 25, 2018 5:50 AM (in response to Norbert Maijoor)Hi Norbert ,
Regarding this new dimmesion we have created , which we called "TYPE" now has values new, existing,missing,total and Toal(ex missing)
After learning this I have created one more dimension in the similar fashion called it " TYPE(DOM/INTL) " with values "Domestic" ,"International" and "Total" in it .
Now I want to have a view like below : -
So I created 2 new dimension one as TYPE(DOM/INTL) , and TYPE(new/existing)
But when I get both of these dimensions in ROWS like below : I can only see "TOTAL" for "international " and rest of the value (new , existing ,missing,total(Ex.missing) DOES NOT even show up .
Is there any restriction in tableau, to use dimensions like this way ?
How do I get to display all the values of TYPE(new/existing) against TYPE(DOM/INTL)
Thanks,
Anoosha