I am trying split a date and time string into separate date and time components, i.e. 01/04/2020 11:45:00 into 01/04/2020 and 11:45:00.
Can anyone help me create the a custom dimension or custom table calculation for this?
This has to be defined as a custom dimension and not within the view file itself?
I’m not certain how to do this just as a dimension because, for whatever reason, you cant cast in a custom dimension. But you can cast in a custom calculation.
If you can do this in the model itself, though, that is the best idea. Your database dialect will certainly have the appropriate functions to do this correctly.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.