Drill down from one table to another table with selection of specific column.

[prag07]

I have two tables joined with each other with key ObjectId which is combination of many things and have one to many relationship type.

Table A:

Error % > 0% and < 100% is only considered as errors

Location	Check	Category	Error Description	Error %	Resolution
A1	Complete	Product	Users column should be filled in	95%	5
A2	Correct	Operation	If Country is USA, then Usage is ‘2’	91%	9
B1	Consistent	Resource	Check status should have red status	53%	2345
B2	Complete	Operation	Task column should be empty	85	18
C1	Correct	Product	CalenderID should be X	100%	0

Table B : Detailed table ( Grey are default columns)

Country	Location	region	Description	User	Usage	Check Status	Task ID	Calender Entity
USA	A	EAST	ABC		2
Mexico	B	SOUTH	PQR
USA	C	NORTH	STU		3
USA	A	EAST	ABC				nl
Mexico	B	SOUTH	PQR		4		av
USA	C	NORTH	STU

And so on…..

Problem 1: If I select One of the Error Description from Table A (highlighted in pink) and drill down to another page having table B

Then expected result should be

Country	Location	region	Description	Usage
USA	C	NORTH	STU	3
USA	A	EAST	ABC
USA	C	NORTH	STU

And 6 more rows with a highlighted column.

Problem 2: If I select One of the Error Description from Table A (highlighted in blue) and drill down to another page having table B

Then expected result should be

Country	Location	region	Description	Task ID
USA	A	EAST	ABC
Mexico	B	SOUTH	PQR
USA	C	NORTH	STU
USA	C	NORTH	STU

And 14 more rows as resolution action has 18 count.

Thankyou

[prag07]

Hi v-tianyich-msft,

Thankyou for the response.

I'm doing exactly the same but I need specific column to be displayed when one error

description is selected. Currently, I'm getting all the columns which are non relevant to the error.

Only default column and column related to Error description is needed as result of Drill through.

Example:

Country	Location	region	Description	User	Usage	Check Status	Task ID	Calender Entity
USA	C	NORTH	STU		3
USA	A	EAST	ABC				nl
USA	C	NORTH	STU

[Anonymous]

Hi @prag07 ,

Then you may need to create a separate table visual object for the Error description. Then you can drill through this visual object.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[prag07]

Note : I'm applying drill through but how can I select specific column?

[Anonymous]

Hi @prag07 ,

Putting the Error Description in the page being drilled through and then drilling down, you can view the following results:

When select B :

When select D :

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.