2 Replies Latest reply on Sep 26, 2018 9:19 PM by Praks Sha

    Show/hide sheets in the dashboard

    Praks Sha

      Hi All,

      Need your help in this.

       

      I have a dashboard which has 3 different sheets.

      1. Sheet 1 - has filter named Hospital

      2. Sheet 2

      3. Sheet 3

       

      I need to implement below functionality.

      Intially user should only see Sheet 1. When the user will make any selection in filter called 'Hospital' in Sheet1 then sheet 2 should appear.

      Then user will make any selection in Sheet2, then Sheet3 should appear.

       

      thanks.

        • 1. Re: Show/hide sheets in the dashboard
          meenu choudhary

          Hi Praks,

           

          You can refer below link for solution:

           

          Re: Dynamically Hide worksheets on dashboard

          • 2. Re: Show/hide sheets in the dashboard
            Praks Sha

            Hi Meenu,

            Thanks fro your reply.

            My requirement is bit different here.

             

            I have a dashboard which has 3 different sheets.

            1. Sheet 1 - has filter named Hospital

            2. Sheet 2 - if user selects a hospital, then Sheet 2 will give a list of all the branches of that hospital. If filter is  set to 'ALL' this sheet would not appear

            3. Sheet 3 -  will display the number of patients for each selected branch in Sheet2, Otherwise should be blank.

            I need to implement below functionality.

            Initially user should only see Sheet 1. When the user will make any selection in filter called 'Hospital' in Sheet1 then sheet 2 should appear. if the filter value is 'ALL' then sheet 2 should not be displayed.

            Then user will make any selection in Sheet2, then Sheet3 should appear.