4 Replies Latest reply on Sep 26, 2018 10:46 AM by venkatram

Display Measure Names as Hierarchy

Preeti Gupta Sep 14, 2018 11:58 AM

(Using Tableau 10.3) I have a table schema similar to as below - Oracle Table 1 (Column based table structure). I have another table where relationship of Subject and group is defined. Subject corresponds to column headers in Oracle Table 1.

Oracle Table 1

Student Name	Phone	Address	Sub 1	Sub 2	Sub 3	Sub 4	Sub 5
Leo	4543545435	abc	45	67	45	43	76
Mark	4543545436	def	76	21	43	54	43
Daniel	4543545437	fgh	67	45	56	65	43
Sushi	4543545438	try	32	76	54	54	32
Drew	4543545439	yui	35	34	43	43	56
Michael	4543545440	ytu	75	23	23	32	43
Richard	4543545441	iuo	32	98	21	45	21

Oracle Table 2

Subject	Group
Sub 1	Group 1
Sub 2	Group 1
Sub 3	Group 1
Sub 4	Group 2
Sub 5	Group 2

The output I need is as below

Student Name	Phone	Address	Group 1	Group 2
Leo	4543545435	abc	157	119
Mark	4543545436	def	140	97
Daniel	4543545437	fgh	168	108
Sushi	4543545438	try	162	86
Drew	4543545439	yui	112	99
Michael	4543545440	ytu	121	75
Richard	4543545441	iuo	151	66

Group 1 and Group 2 should be expandable i.e. on expanding Group, Output should be

			Group 1			Group 2
Student Name	Phone	Address	Sub 1	Sub 2	Sub 3	Sub 4	Sub 5
Leo	4543545435	abc	45	67	45	43	76
Mark	4543545436	def	76	21	43	54	43
Daniel	4543545437	fgh	67	45	56	65	43
Sushi	4543545438	try	32	76	54	54	32
Drew	4543545439	yui	35	34	43	43	56
Michael	4543545440	ytu	75	23	23	32	43
Richard	4543545441	iuo	32	98	21	45	21

Note - I can't transpose this table to row based data source. Reason is I have more than 80 millions of records.

1. Re: Display Measure Names as Hierarchy

Soham Wadekar Sep 14, 2018 12:09 PM (in response to Preeti Gupta)

Hi Preeti,

Fistly- > bring your Table 1 in Tableau and pivot your Sub1.. Sub5 to get this

I have renamed the pivot columns to Subject and Grade.

2. After this bring in your second table and join it on subject to get this
3. Create a hierarchy of group and subject (from the second table)

and then arrange them as follows
expanded->

Hope this helps

Soham
Like Show 0 Likes(0)

Actions
2. Re: Display Measure Names as Hierarchy

Preeti Gupta Sep 14, 2018 1:08 PM (in response to Soham Wadekar)

Hi Soham,

Thanks for your response. I can't pivot the columns because I have more than 80 millions of records. In a given example, I have considered 5 columns (Sub 1.. Sub 5) but in actual, I have 100 columns likewise. If I go with pivoting the columns, performance is getting worst.

Thanks,
Preeti
Like Show 0 Likes(0)

Actions
3. Re: Display Measure Names as Hierarchy

Preeti Gupta Sep 26, 2018 10:41 AM (in response to Soham Wadekar)

Do you have any other suggestion?
Like Show 0 Likes(0)

Actions
4. Re: Display Measure Names as Hierarchy

venkatram Sep 26, 2018 10:46 AM (in response to Preeti Gupta)

As per as I know, you need to maintain a database for huge file. Pivot is good for limited number of columns and rows. You check alternative ways of data extraction into tableau.
Like Show 0 Likes(0)

Actions