Creating column for first date

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. 

0 2 260
2 REPLIES 2

Dawid
Participant V

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. 

Top Labels in this Space
Top Solution Authors