Cannot use EXTRACT() Function

[FamilyMan]

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!

[Dawid · Accepted 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

[FamilyMan]

Thanks @Dawid . I'm a total rookie here. This is helpful.