Create a visual table with one ID linked to multiple categories or details

[Riaz_R]

Good day,

I created a viual (tabel) but the outcome is not what i expected.

Issue:

1. The system displays one ID 3 times and links each ID to a category or detail in three seperate rows (see picture).

Expected:

What i planned to display was one ID linked to to several categories or details in one row (See table 1).

Issue:

2. The duration is summed up per ID which is good but it is not what i planned.

Expectation:

Display the duration per category (See table 1).

Ive attched a sample data in table 2.

Could you kinldy assist with the issue ?

Appriciate you help 

Table 1

Equip_IDENT	DOWN	DURATION	DELAY	DURATION	STANBY	DURATION
A32	Reason 1	0.8	Reason	1.3	Reason	3
A35	Reason 10	0.2	Reason	1.1	Reason	7

Table 2

SHIFT_DATE	SHIFT_IDENT	EQUIP_IDENT	SUPER_GROUP_NAME	STATUS_CATEGORY	Status	DURATION_HOURS
00:00.0	1	A32	AA	DOWN	Reason 1	2.40805555
00:00.0	2	A32	AA	DOWN	Reason 1	10.8536111
00:00.0	1	A33	AA	DOWN	Reason 2	6.821666667
00:00.0	1	B19	BB	DOWN	Reason 2	1.144166667
00:00.0	1	Z38	AC	STANDBY	Reason 10	1.944722217
00:00.0	1	Z35	AC	STANDBY	Reason 10	8.2975
00:00.0	2	B19	BB	STANDBY	Reason 15	0.70305555

Picture of what the system is providing me

Thank you

Cheers

[Riaz_R]

@Greg_Deckler 

I tried it out but dont fully understand how to implement it.

The matrix does provide a view that parially resembles what i have in mind, but it is missing the duration between the categories and also the staus related to the categories.

Could you provide me more info on how to implement your solution ? 

[Greg_Deckler]

@Riaz_R Use a Matrix instead of a table visual.

[Riaz_R]

@Greg_Deckler 

So i tried it but dont know how to make the setup in order for it to work properly.

i am not able to add the status under the category names. 

Looking at the picture (left), the status is currently minimized (+).

How guide me through the process ?

[Greg_Deckler · Accepted solution]

@Riaz_R Sure, hope this explains it: