Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
I’m using BigQuery and tried to use a “Last Quarter” date filter in the table_date_range LookML function and received the following error: Failed to retrieve data - Time expression is too long: TIMESTAMP ( DATE_ADD ( DATE_ADD ( TIMESTAMP ( CONCAT ( STRING ( YEAR ( DATE_ADD ( TIMESTAMP ( CONCAT ( STRING ( YEAR ( TIMESTAMP ( CONCAT ( STRING ( YEAR ( TIMESTAMP ( CONCAT ( CURRENT_DATE ( ) , ' 00:00:00' ) ) ) ) , '-' , LPAD ( STRING ( ( ( QUARTER ( TIMESTAMP ( CONCAT ( CURRENT_DATE ( ) , ' 00:00:00' ) ) ) - 1 ) * 3 ) + 1 ) , 2 , '0' ) , '-01' ) ) ) ) , '-' , LPAD ( STRING ( ( ( QUARTER ( TIMESTAMP ( CONCAT ( STRING ( YEAR ( TIMESTAMP ( CONCAT ( CURRENT_DATE ( ) , ' 00:00:00' ) ) ) ) , '-' , LPAD ( STRING ( ( ( QUARTER ( TIMESTAMP ( CONCAT ( CURRENT_DATE ( ) , ' 00:00:00' ) ) ) - 1 ) * 3 ) + 1 ) , 2 , '0' ) , '-01' ) ) ) - 1 ) * 3 ) + 1 ) , 2 , '0' ) , '-01' ) ) , - 3 , 'MONTH' ) ) ) , '-' , LPAD ( STRING ( ( ( QUARTER ( DATE_ADD ( TIMESTAMP ( CONCAT ( STRING ( YEAR ( TIMESTAMP ( CONCAT ( ST
@rsmichaeldunn and I, @Peter_Krengel, are looking to expand our teams, come hear us talk about our use of Looker at JOIN the Tour Seattle. If you love turning measurement into business change as part of a central analytics team, take a look at the business analyst positions: Senior Business Analyst Business Analyst If you love enabling rapid access to data and building tools used across a growing company, reach out directly: Business Intelligence Engineer Apply directly with the links above, email me (peter@), or take a look at our careers page: https://www.realself.com/careers
RealSelf, the TripAdvisor for cosmetic procedures, is looking to expand the analytics team with 2 positions. Business Analyst will actively use Looker to help internal teams make data driven decisions. Business Intelligence Analyst will write LookML and help determine how and what to track for new features on the site. Apply directly with the links above, email me (peter@), or take a look at our careers page: https://www.realself.com/about/jobs
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.