1 Reply Latest reply on Apr 13, 2018 4:58 AM by Mark Bradbourne

    Dynamic Filter Options

    Mark Gordon

      Hi

       

      I am working on a viz that has two data sources linked to Google Analytics, each of which uses different measures (users, sessions, pageviews and transactions for one, and quantity in the other).  I want to combine both into a single map view, and allow the user to select teh domain first and then the dimensions appropriate to each one.

       

      I've set up a parameter to switch between the two domains, and then set up a calculated field based on the parameter selection to use as the filter.  I've tried the following code in the calculated field -

       

      IF [Domain] = 'Domain1' THEN 'Users'

          ELSEIF [Domain] = 'Domain1' THEN 'Sessions'

          ELSEIF [Domain] = 'Domain1' THEN 'Pageviews'

          ELSEIF [Domain] = 'Domain1' THEN 'Transactions'

          ELSEIF [Domain] = 'Domain2' THEN 'Quantity'

      END

       

      - but this only shows Users for Domain1 and Quantity for Domain2.  Is there a way to build up a list of options so when Domain1 is selected each of the options is displayed in the filter list?  Or, is there a simpler way of doing this altogether...?

       

      Thanks

      Mark