8 Replies Latest reply on Sep 26, 2018 7:30 AM by Anya Perfilyeva

    Tree Map swap on dashboard using parameter control - how to fix

    Harley Ellenberger

      I saw a few posts regarding the logic presented in this article....

      Alan Smithee Presents: Changing Viz Types with Dashboard Containers and Parameters

       

      The problem I was having was that tree maps weren't filling the layout containers correctly after I changed my parameter control.  I believe there could be other chart types that were presenting the same problem.  See attached sample.twbx for an example of the problem dashboard.

       

      It appears that the worksheets for the tree maps don't revert to a completely blank state when you change the parameter selection...

      diff.jpg

       

      My solution was to create a "blank" calculated field and pull that out to the columns shelf and hide the header.  See attached sample-fix.twbx for my solution.  Once you put the blank calculated field on the columns shelf, the worksheet will revert to a completely blank state when you change the parameter selection.  As a result, the tree maps now completely fill the layout container on the dashboard.

       

      Just wanted to share my workaround.