Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Building Dashboard for multiple organizations

Hey all, Im working at a research institute that conducts surveys for clients. Our DB is built like this:   Organization Key Name Date Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 ...
Need Help
nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

In the PowerQuery editor, you can pivot the questions & responses into two columns. This means all the questions should come under one column and answers should come in the next column. 

This way you can slice and dice information as you needed.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hey nvprasad ,

    It's a really good idea!

    And how would you cross between organizations? A page navigation to the organization?

    Is this means that we'll need to build a report for each organization? 

    • nvprasad's avatar
      nvprasad
      Icon for Solution Sage rankSolution Sage
      6 years ago

      Hi,

       

      Since information needs to be shared only with the respective organizations of their data.

       Below are the options in my mind and the option is my pick.

      1. We can build a single report and use Row Level Security to allow users to see only their data.

      2. Build multiple reports and share them with the respective organization.

       

      Appreciate a Kudos! 🙂
      If this helps and resolves the issue, please mark it as a Solution! 🙂

      Regards,
      N V Durga Prasad