My Looker chart is using a 'DateTime' field in the Date Range Control. This field is in the format 'YYYY-Mon-DD HH:MM:SS' (e.g. 2024-Apr-30 14:53:25). In addition to the date level filtering, I would to be able to filter at the timestamp level (HH:MM).
1. How may I use the 'DateTime' field to filter at the hour and/or minute level granularity?
2. Is it possible to have a preselected default for timestamp? For instance, something like selecting a default value for the Date Range Control (Today, or 1 week, etc.). My use case is to be able to display results for the last 2 hours by default.
Please let me know if addition info is needed.
Thank you!
Hello @invisible ,
For both of your questions, I believe you can consider the following:
Hope this helps.
Thank you, @maricarp! I looked into those filters and I do not see an option to use LookML. I did a bit more digging and I am not sure if I am understanding this correctly -- I am using 'LookerStudio' (basic license, not pro). Can LookML be used with LookerStudio, or do I need a pro license to use it?
Are there any other options in the basic Looker studio that would allow time level filtering granularity, and setting those defaults?
Thank you!
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |