Forum Discussion

jjasper's avatar
jjasper
Helper II
8 years ago

drill though mutiple views

Hi, 

 

I am trying to figure out a way to have multiple views and drill though them. I currently have a graph created that drills through: Organization -> Village -> Domain -> Question -> Neighbourhood. I also have a filter that you can use to select different views for example you only want to see east side you would click east and will filter out the villages that belong to the west side. 

 

What I would like to do is when the organziational filter is selected that you would be able to drill down to the question but instead of going to the neighbourhood level it would go the village level again and from there you could the graph from a village stand point and drill into that village specifically. 

 

I hope this makes sense. 

 

Jes

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi jjasper

    when the organziational filter is selected that you would be able to drill down to the question but instead of going to the neighbourhood level it would go the village level again

     

    For this requirement, I make a test, please check to see if it meet your needs.

     

    from there you could the graph from a village stand point and drill into that village specifically. 

     

    I don't understand how to "drill into that village specifically", does this mean drilling through:

    Village -> Domain -> Question -> Neighbourhood?

     

    Best Regards

    Maggie

     

     

    • jjasper's avatar
      jjasper
      Helper II

       Hi Maggie,

       

      That is similar to what I am looking for.

       

      When I say drill into that village specifically, I have it set up that you can drill through for a specific village. All the villages are listed then you click on a village bar in the graph and it will take you to the domain averages for that village then to the questions for that domain then down to the neighbourhood for a specific question.

       

      I want to be able to do the same thing but from an organizational view. GO from the overall organization into the domains into the questions then into the villages instead of the neighbourhood. Once on the village screen I would like to go into the a specific village domain then to questions then to neighbourhood.

       

      I Tried to upload the file but couldn't figure out how to do it.

       

      Jes

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support

        Hi jjasper

        an example of your data model and expected result would be better for analysis.

        You could attach your file by "Browse" file in your computer.

        Or you can upload your file to onrdrive, then share the link to me.

         

        Best Regards

        Maggie