Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple level Hierarchy/Drilldown

I am currently struggling to format a chart with multiple levels of hierarchical data. An example of this data is    Operations Air & Climate Greenhouse Gas Emissions Outdoor Air Quality Bui...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

You will have to modelate your tables in order to get these categories in rows instead of in columns. May be you can create a table with all the categories and make a relation between schools (with the lowest level category in a row ) and your dimension table called categories.

 

CATEGORY 1     CATEGORY 2     CATEGORY 3                                                SCHOOL ID         CATEGORY 3

         A                    AA                    AAA                                                                 X                         AAA

        A                     AA                    AAB                                                                 Y                          BBA

        A                     AB                    ABA               ------------------------->            Z                         ABA

        B                     BA                    BAA

        B                     BB                    BBA

 

 

Regards

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    markross92..... 

     

    I apologize if I am misunderstanding but if I only have my lowest level of data present then I would not be able to drilldown through? For example having a bar chart with just total "Operation" for each school, then drill to "Air&Climate" and "Buildings" for each school and so on.