Forum Discussion

ljmgordon's avatar
ljmgordon
Frequent Visitor
3 years ago
Solved

Ragged Hierarchy in a Matrix

Hi, folks,   I'm trying to build a dashboard to show data quality results per node in our Information Architecture Framework. My issue is: our hierarchy is ragged, some nodes are at L4, some at L6....
Need Help
  • ljmgordon's avatar
    ljmgordon
    3 years ago

    Yup, that's the exact page I used to build my measures, but I still have this lowest level blank like you see in the screenshot. 

     

    However, I did just manage to solve it by changing the "Total Rules" measure by making it 

    [IAFBrowseDepth] < [IAFRowDepth]

     And now I do still actually see a + next to the bottom level, but there's no new row when I click it. Hurrah!

ljmgordon's avatar
ljmgordon
Frequent Visitor
3 years ago

Yup, that's the exact page I used to build my measures, but I still have this lowest level blank like you see in the screenshot. 

 

However, I did just manage to solve it by changing the "Total Rules" measure by making it 

[IAFBrowseDepth] < [IAFRowDepth]

 And now I do still actually see a + next to the bottom level, but there's no new row when I click it. Hurrah!

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi ljmgordon ,

     

    The + will not disappear since for all purposes there is still a level below that one, on some of the specific rows theres is no values then it won't show anyting, but for the rest it will present correct values.

     

    Don't forget to mark the correct answer to help others.