Forum Discussion
Lost in Model
Hi, i have following data set, and want to create a matrix like this: i go on and separte the tables but now i have the problem how can i calculate Status and Hours? wich advice sh...
Maybe on have an idea where is my brain bug.
Conntection between tables is alway [issue_id] - [parend_issue_id]
E1
E2
E3
T Epic (E1), T Task(E2) and T Sub-Task(E3)
is queried via SELECTEDVALUE() in the respective table (E1, E2, E3). And I notice I don't necessarily get the value per level that I expect.
The relationships are currently always set to BOTH between the 3 tables, if I change this to SIMPLE the display in the table is incorrect, i.e. there are also not associated tasks displayed under the EPIC and also the problem that EPIC is not recognized correctly is still there.