Question

This content is likely not relevant anymore. Try searching or browse recent questions.

Geoffrey Bell Original Poster

5/9/19

Filter Data to < Current Hour

Hey Guys,

I do a lot of day-of reporting and one of the things I'm trying to do is compare today's performance to another day. The trouble is I'm trying to comp. to that day to the last full hour. Essentially filter out all data in that comp day that happened after the last completed hour.

I've accomplished this in Tableau but I'd like for this report to be done in Data Studio. Is there a way to do this? I'm guessing this would have to be a custom metric but not sure how to do it.

Thanks for any help.

Details

Report and Visualize

Pinned

Locked

Latest Update Latest Updates (0)

Recommended Answer Recommended Answers (0)

Relevant Answer Relevant Answers (0)

All Replies (1)

Geoffrey Bell Original Poster

5/9/19

Recommended Answer

Relevant Answer

For what it's worth this is how I accomplished this in Tableau:

IF [Date1] = [Comparison Date]

AND [Session Hour (int)] <= [Current Hour]

THEN

[Revenue GA]

END

Google user

recommended this

Original Poster

Geoffrey Bell

marked this as an answer

Recommended based on info available

Helpful?

This question is locked and replying has been disabled.

Subscribe to updates

Write a reply

10 characters required

Failed to attach file, click here to try again.

Edit link

Text to display:Link to:

Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

Link to post

This will remove the reply from the Answers section.

Report post

What type of post are you reporting?

Off-topic

Post is disrespectful, about third party products or contains unrelated content or personal information.

Abuse

Post contains harassment, hate speech, impersonation, nudity; malicious, illegal, sexually explicit or commercial content.

Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Google user

This reply is no longer available.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

Google Employee — Google product team members and community managers

Community Specialist — Google partners who help ensure the quality of community content

Diamond Product Expert — Community members with product mastery who help other Google users and Product Experts

Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts

Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions

Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions

Product Expert Alumni — Former Product Experts who are no longer members of the program

Community content may not be verified or up-to-date.