Forum Discussion

rodneyc8063_1's avatar
rodneyc8063_1
Helper V
7 years ago
Solved

Table (Matrix) Visual that Allows Multiple Row Groupings?

In our current reporting tool, we are able to have multiple row groupings displayed at the same time such as this So I have a "Home Faculty short Desc" row grouping, as well as a second "OUAC ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi rodneyc8063_1 ,

    By my tests, I'm afraid that we cannot achieve your desired output in matrix currently. 

    For drill down, it is only able to drill sequentially down.

    Best  Regards,

    Cherry

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Hello rodneyc8063_1 

If you turn off "Stepped layout" under the Row Headers then drilldown I think you will have what you are looking for.

rodneyc8063_1's avatar
rodneyc8063_1
Helper V
7 years ago

Hi jdbuchanan71 

 

Thanks for this, this does get me a step closer.

 

Though I have another question regarding drill downs and hierarchies.

 

Lets say for example I have the following hierarchy

 

From what I can tell, I can only drill from top to bottom sequentially.

 

Is there a way that I could show BOTH the [HOME_FACULTY_SHORT_DESC] and [OUAC_CHOICE_GROUP] side by side at the same time while preserving the hierarchy from [HOME_FACULTY_SHORT_DESC]?

 

So the intial visual shows the two columns side by side (as shown in my first screen shot in my first post) but also allow drilling for the first column?

 

Or when drilling, is it ONLY able to drill sequentially down? And therefore I cant show more then one row grouping?

 

I hope this makes sense, difficult to word

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi rodneyc8063_1 ,

    By my tests, I'm afraid that we cannot achieve your desired output in matrix currently. 

    For drill down, it is only able to drill sequentially down.

    Best  Regards,

    Cherry

    • rodneyc8063_1's avatar
      rodneyc8063_1
      Helper V
      7 years ago

      Hi v-piga-msft 

       

      Thanks for verifying this

       

      I wasnt sure if it was possible, but its good to know that it is not - Much appreciated!

    • rodneyc8063_1's avatar
      rodneyc8063_1
      Helper V
      7 years ago

      Hi v-piga-msft 

       

      Actually, I just wanted to double check

       

      Is there potentially ANY visual out there that can potentially achieve this functionality?