I am trying to define a goal based on an engagement metrics. Specifically i have a Journey that uses a Data Extension as a Source. Then I have created another Data Extension where i keep the tracking data (in my case opens) which i retrieve via SQL and shows me the people that have opened the emails send from the Journey.
I want to be able to set the goal in my journey for 50% of the population to have opened the email.
I have created a 1:Many relationship in Contact Builder and in the Goal i am using this secondary data extension for defining the Goal Criteria.
Print screens below. Goal for this Journey stays at 0% in the UI. I can confirm that the SQL pulls the correct data.