2 Replies Latest reply on Aug 27, 2018 9:45 AM by rick.nguyen.0

    How to set filter from parameter for custom view

    rick.nguyen.0

      Dimensions of interest:

      1. Event Number

      2. Event Date

      3. Event City

      4. Full Event Details (event number + event date + event city).

       

      Sample data:

       

      Event NumberEvent DateEvent CityFull Event DetailsRevenue
      20171102017/03/08Seattle2017110 - 2017/03/08 - Seattle$200
      20180542018/01/03Alaska2018054 - 2018/01/03 - Alaska$120
      20181112018/03/03Seattle2018111 - 2018/03/03 - Seattle$350
      20182422018/05/03Arizona2018242 - 2018/05/03 - Arizona$400

       

      Desired outcome:

      User types in an event number in parameter (i.e. 2018111) and there will be a comparative trend of Seattle's revenues for the month of the event (March) and also compares Seattle's results from the same month last year.