Can anyone help me understand why when I try to create a custom dimension I cannot use the EXTRACT() function? There are other functions that I thought would work like DATE() as well, but for some reason these functions aren't accepted. Thanks!
Solved! Go to Solution.
Hi FamilyMan,
Are you trying to use SQL functions there? If so, that won't work. You still have to use Looker functions similarly to Table Calculations. There are some differences - couple of functions are only available in Table Calculations:
Here is the doc: https://cloud.google.com/looker/docs/functions-and-operators
Hi FamilyMan,
Are you trying to use SQL functions there? If so, that won't work. You still have to use Looker functions similarly to Table Calculations. There are some differences - couple of functions are only available in Table Calculations:
Here is the doc: https://cloud.google.com/looker/docs/functions-and-operators
Thanks @Dawid . I'm a total rookie here. This is helpful.