5 Replies Latest reply on Oct 12, 2016 5:52 PM by Yuriy Fal

    How can I force a workbook to always have one option selected in filter?

    Jack Smith

      My data source consists of basically a union between two source systems (see example below).

       

      Select  Name, Location, Favorite Sport, NULL Age, DB1 as Source  FROM database 1

       

      UNION

       

      Select  Name, NULL Location, Null Favorite Sport, Age, DB2 as Source from database 2

       

      The issue I'm running into is now whenever I give the option for the user to select "Location" in the dashboard, they will also have to choose NULL in order to not to lose data from the 2nd database. Is there a way for me to always force the dashboard to keep "NULL" but not show it in the list of locations for the user to filter from? Let me know if this is not clear and I can try to clarify some more.