Question

Custom Filter Request

  • 27 January 2021
  • 1 reply
  • 65 views

The overall goal of the look I am going to create is to pull a list of accounts that have sent their first visit in the past week.  Let me explain what will be apart of this look. 

The dimension we have is the complete date which I have set as “is in the past 1 complete week”, but the issue I am running into is creating the custom filter based off of the measure Visit Count to make sure that equals 1 in an overall sense and not just based off of the count from the past week.  

 

Any guidance is much appreciated, and if you need more information I will provide that.   


This topic has been closed for comments

1 reply

Hi @matthewc ,

 

It sounds like you could achieve this by first creating a measure to calculate the first visit date of an account, e.g. (update according to your dimension names):

  measure: first_visit_date {
type: date
sql: MIN(${visit_date}) ;;
}

And then filtering on ‘First Visit Date is in the past 1 complete week’ in your Look. If you have pulled through your account ID or name as a dimension in your Look, then this will filter on accounts with a first visit date in the past 1 complete week.

Please let me know how you get on with this, and if you have any questions.

 

Best wishes,

Shaan