Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unable to figure this problem out

Hi All,   I hope someone can help here, I have 2 tables called Epic and Tasks pulled from JIRA.   Tasks contains  the EPIC_PARENT_LINK, which is where you can match up the data, I have created a ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Might help although I do not think I have included MM3TR&R yet which is kind of what you are looking for. Try something like below. Basically at the "group" level (first hierarchy level) you are going to have multiple Tasks. So, if you have only a single Task, then you are at the second level of the hierarchy, otherwise, you are at the top level of the hierarchy. This uses HASONEVALUE instead of ISINSCOPE but same concept.

    Measure =
  IF(
    HASONEVALUE('Tasks'[ISSUE_KEY]),
    MAX('Tasks'[SUMMARY]),
    MAX('Epics'[SUMMARY])
  )

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Might help although I do not think I have included MM3TR&R yet which is kind of what you are looking for. Try something like below. Basically at the "group" level (first hierarchy level) you are going to have multiple Tasks. So, if you have only a single Task, then you are at the second level of the hierarchy, otherwise, you are at the top level of the hierarchy. This uses HASONEVALUE instead of ISINSCOPE but same concept.

Measure =
  IF(
    HASONEVALUE('Tasks'[ISSUE_KEY]),
    MAX('Tasks'[SUMMARY]),
    MAX('Epics'[SUMMARY])
  )

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Greg_Deckler Thanks Greg, you are a superstar.