Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Advanced Search Filters allowing matching across different variables.

Avatar

Level 6

21-02-2010

I often come across situations where I want to match one variable or classification with another in a subrelation report.

 

For example,

  1. Billing City = Departure City (to understand how often people buy tickets for flights departing from their own city)
  2. Gender = Product:Gender (to understand if the customer specified gender is same as what the product was targeted to)
  3. Campaign: Target category = Product: Product category (Did visitor buy the same product category for which the campaign was targeted)

(Note - I am using ' : ' to denote classifications here)