6 Replies Latest reply: Sep 14, 2017 10:02 PM by Gordon Lo RSS

    A strange behavior when we hide/show a sheet conditionally

    Gordon Lo

      I cannot replicate this issue with a sample dashboard, but it is happening in our actual dashboards.

      Let me just describe the strange behavior in text.

       

      For example, There are 3 sheets.

      The 'Main' and 'Always Show' sheets always appear.

      The 'Conditional Show' sheet show only when =ONLY(Dim1)='A'.

      2017-09-14_094427.png

       

      However when I select 'C', the 'Conditional Show' still appear.

      2017-09-14_094815.png

       

      Then I switch to other sheets (eg: Always Show), the sheet is hidden at this moment.

      2017-09-14_094941.png

       

      Then I go back 'Main' and choose back 'A', but the 'Conditional Show' sheet is still hidden.

      2017-09-14_095217.png

       

      The sheet appears again only when I switch to another sheet.

      2017-09-14_095345.png

      It seems that the hide/show condition recalculate when I switch between the sheets, but not when I select a value of a dimension.

      The user experience is not good. Any hints about this strange behavior?