Is it possible create a customer dimension in looker for date using string data? Does it need to be in a particular format ie (YEAR-MONTH-DAY as opposed to DAY-MONTH-YEAR)
This topic has been closed for comments
Yes, but it seems like something that should be done in your database, not Looker. Without knowing your database, all I can say is read up on its relevant date functions.
If you are not a lookml developer, there are table calc functions that can get you where you need to go. But since it’s table calc, it’s not reusable from the model.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.