I have orders for a bunch of users and I need to create a column containing the date of each users first order date. Format would be:
| User ID | Order ID | Order Date | First order date(To create) |
|---|---|---|---|
I have the first three columns as fields from my developers but I need to create a custom dimension that gives me the last column. Any help is much appreciated.
You can only achieve that by creating a measure type:date but not dimension, because MIN() is type of aggregation
Can you elaborate anymore on that? I am new to Looker and need this to move on with my project.
I have a column of order IDs and User IDs and I need to find the first time each user placed an order so I can calculate life time value. Which field would I measure and what needs to be filtered? Thank you for the help.