Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

reporting on data in 3 different models

Ok, I come to the many for help again.   So i have the following models:   This is the initiative level,  1 of 2 top level items Rollout level is at the same level as Initiative The...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    So the pattern I use for hierarchies is to check the scope from the deepest level on up.

     

    See if this makes sense to you:

    Status Switch =
SWITCH (
    TRUE (),
    ISINSCOPE ( Story[Issue Key] ),      SELECTEDVALUE ( Story[Status] ),
    ISINSCOPE ( Epic[Issue Key] ),       SELECTEDVALUE ( Epic[Status] ),
    ISINSCOPE ( Initiative[Issue Key] ), SELECTEDVALUE ( Initiative[Status] ),
    ISINSCOPE ( Rollout[Issue Key] ),    SELECTEDVALUE ( Rollout[Status] )
)

     

    If you aren't familiar with SWITCH ( TRUE(), ... ), I recommend reading this:

    https://p3adaptive.com/2015/03/the-diabolical-genius-of-switch-true/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

AlexisOlson I managed to get it to work for my status entry

 

status 1 =
SWITCH (
TRUE (),
ISINSCOPE ( 'Story/Task'[ISSUE_KEY] ), SELECTEDVALUE ( 'Story/Task'[ISSUE_STATUS_NAME] ),
ISINSCOPE ( 'Story/Task'[PARENT_ISSUE_KEY] ), SELECTEDVALUE ( epic[ISSUE_STATUS_NAME] ),
ISINSCOPE ( 'Story/Task'[init/roll key]), SELECTEDVALUE ( initiative[ISSUE_STATUS_NAME] ),
ISINSCOPE ( 'Story/Task'[init/roll key] ), SELECTEDVALUE ( rollout[ISSUE_STATUS_NAME] )
)
 
but for some reason it doesn't work for my Summary entry using the same theory
 
summary 1 =
SWITCH (
TRUE (),
ISINSCOPE ( 'Story/Task'[SUMMARY] ), SELECTEDVALUE ( 'Story/Task'[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[Epic Summary] ), SELECTEDVALUE ( epic[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[initiative summary]), SELECTEDVALUE ( initiative[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[rollout summary] ), SELECTEDVALUE ( rollout[SUMMARY] )
)
 
i thought i'd gotten the idea, but no i lost it less than 5 mins after getting status working.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I worked it out, they weren't linked by summary, so what i did was

 

summary 1 =
SWITCH (
TRUE (),
ISINSCOPE ( 'Story/Task'[ISSUE_KEY] ), SELECTEDVALUE ( 'Story/Task'[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[PARENT_ISSUE_KEY] ), SELECTEDVALUE ( epic[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[init/roll key]), SELECTEDVALUE ( initiative[SUMMARY] ),
ISINSCOPE ( 'Story/Task'[init/roll key] ), SELECTEDVALUE ( rollout[SUMMARY] )
)
 
now it works like a dream, thanks for your guidance.