I am trying to create a custom measure to calculate the days from when a customer first signed up to when they made an order. I have two views: 1. Customers (dimension) 2. Orders (fact) that are joined to create an Orders explore. For each time an order takes place, I want to know how many days it has been since the customer signed up. I created a custom dimension using diff_days(order_date, signup_date) = days_since_signup but now when I try and aggregate the dimension to get an average it gives me the error Measure "average_of_days_since_signup" depends on fields from multiple views which is not supported for custom measures.
How can I achieve this without having to model it in the data?
LinkedIn
Twitter
