Forum Discussion

KIL2022's avatar
KIL2022
Regular Visitor
3 years ago

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 should i give in the measure for right calculation?

Need Help

2 Replies

  • KIL2022's avatar
    KIL2022
    Regular Visitor
    3 years ago

    what I have found out in the meantime
    Yello = expecatation

    The problem is, when there is only 1 Enty in the next level, i get back wrong result on higher level


    Maybe one have an idea.

     

  • KIL2022's avatar
    KIL2022
    Regular Visitor
    2 years ago

    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.