Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

- - Knowledge base
Product Announcements
Events
Groups

Community
Exploring & curating data
Dashboards & looks
Date filter comparisions

Question

Date filter comparisions

5 years ago
4 August 2017
1 reply
378 views

Tracy.Sit
0 replies

Is there a way filter data to compare today’s current data (based off beginning of day to current hour) to the same time frame yesterday (beginning of day to current hour)?

Similarly, is there a way to filter data to compare the past 7 days to the previous 7 days no matter what day of week it is?

Like
Quote
Share

1 reply

Oldest first

Newest first Best voted

Userlevel 2

philip.martinelli
Looker Staff
37 replies
5 years ago
5 August 2017

Hi Tracy!

I’ve linked a couple options worth exploring below:

[Retired] Timeframe vs Timeframe Analysis LookML

The content of this article has been updated and migrated to a Looker Help Center article.

This option essentially uses two filtered measures that respond to inputted UI filter values

Comparing a previous week to that same week last year Exploring

It is common to want to compare sales, revenue, etc. between a week this year to the same week previous years. Let’s say you want to compare last week to the same week last year.
###Weeks starting on Monday
If you are using Looker’s default weeks starting on Monday, you can do this easily creating a matches(advanced) filter on date for
1 week ago for 1 week, 53 weeks ago for 1 week

This will give you something like this:
[image]
###Weeks not starting on Monday
If you want to analyze weeks…

This option uses a matches advanced filter expression

If you have further questions, feel free to hop on chat or visit us at help.looker.com

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.