Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

- - Knowledge base
Product Announcements
Events
Groups

Community
Exploring & curating data
Dashboards & looks
Can time frames support half-months?

Question

Can time frames support half-months?

5 years ago
3 January 2018
1 reply
362 views

sebastian
Member
7 replies

Hi, I’d like to have a timeframe that is 2 weeks long.

Is that possible within looker’s pre-defined timeframes? If not, can I make one of my own in lookml?

Thanks!

-Sebastian

Like
Quote
Share

1 reply

Newest first

Oldest first Best voted

Ellio
Looker Staff
31 replies
5 years ago
4 January 2018

Hey Sebastian!

This discourse article covers how to create a dimension that acts as a biweekly timeframe:

I need a Bi-Weekly Timeframe Modeling

Bi-Weekly timeframes can be really useful! For now, using SQL is the best way to achieve this.
In Redshift, here’s one way to go about it. Read the comments through the SQL to understand what each line does:
SELECT
--TO_CHAR(DATE_TRUNC('week', CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', account.createddate)), 'YYYY-MM-DD') AS "account.createddate_week", --Looker-generated week SQL

CASE WHEN
MOD(extract(week from account.createddate),2) -- this returns 0 or 1 based on whether the week num…

Best,

Elliot

Like
Quote

Reply

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.