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 1Equip_IDENTDOWNDURATIONDELAYDURATIONSTANBYDURATIONA32Reason 10.8Reason1.3Reason3A35Reason 100.2Reason1.1Reason7 Table 2SHIFT_DATESHIFT_IDENTEQUIP_IDENTSUPER_GROUP_NAMESTATUS_CATEGORYStatusDURATION_HOURS00:00.01A32AADOWNReason 12.4080555500:00.02A32AADOWNReason 110.853611100:00.01A33AADOWNReason 26.82166666700:00.01B19BBDOWNReason 21.14416666700:00.01Z38ACSTANDBYReason 101.94472221700:00.01Z35ACSTANDBYReason 108.297500:00.02B19BBSTANDBYReason 150.70305555 Picture of what the system is providing me Thank youCheers

Riaz_R Sure, hope this explains it:

Frequent Visitor

1 year ago

Solved

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

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

Table 2

Picture of what the system is providing me

Thank you

Cheers