Stack Overflow
Stack Overflow

Questions tagged [looker]

Use this tag for questions concerning use of the Looker platform or its modeling language, LookML.

The Looker data platform is a web-based service for data exploration, analysis, and reporting with built-in version control and security features. Google announced in June 2019 that it would acquire Looker Data Sciences.

LookML is a declarative data modeling language somewhat similar to YAML or JSON that defines relationships in relational databases so that users of the Looker platform can explore data without writing SQL.

Components of LookML and their related SQL concepts:

  • dimension (column)
  • measure (aggregation)
  • view (table)
  • explore (join)
  • model (database)

Data types peculiar to LookML include:

  • duration
  • yesno (equivalent to boolean)
  • location
209 questions
1
vote
1 answer

In Looker, how do I find the max of a measure while using the sum function if available dimensions are omitted?

I am trying to find a way to visualize the max of a measurement over time. However, this measurement has multiple dimensions that it can be broken down by. Imagine the source data is a table like this where max_thing is an already pre-aggregated max…
grg-n-sox
  • 717
  • 2
  • 5
  • 25
1
vote
0 answers

Reporting on multiple log files

We're using Looker for analytics and one connection streams in log files which are setup as new tables. They're basically all the same structure. The other connections show dimensions in a manner I'm used to within one file. How do I aggregate the…
ronin1127
  • 11
  • 2
1
vote
1 answer

How to return JSON object in Javascript?

I am having issues with returning a JSON object. When I render the webpage, nothing shows up. Does anyone know how to fix this? Sorry, I am new to Javascrtipt. import React, { useEffect, useState, useContext } from 'react' export const MarketData =…
Renee R
  • 21
  • 1
  • 3
1
vote
2 answers

Materialized Views not showing in Looker?

After connecting my PostgreSQL 11.11 to Looker, I am unable to see the marginalized views created in my database. Is there a reason they aren't showing there?
thecodingancora
  • 11
  • 2
1
vote
1 answer

Why is window.open not working with Looker's Extension Framework?

I am trying to use window.open in a javascript onclick function for a clickable embedded image. For some reason it is not working. I am trying to embed this into a Google Looker extension framework. Edit: When I open the webpage on Looker Extension…
Renee R
  • 21
  • 1
  • 3
1
vote
1 answer

Looker CSP issue: Unable to load looker reports in iframe

I am using an iframe to load the looker dashboard in our angular application but getting the below error. Refused to frame 'https://looker.lab.redseal.net:9999/' because it violates the following Content Security Policy directive: "default-src…
Mr. Raj Kale
  • 87
  • 1
  • 1
  • 7
1
vote
1 answer

Google Calendar and Looker integrations

Is it possible to sync between Google calendar and Looker? I want to pull out events through their API, and store them in my calendar table. I searched and didn't find a solution that does not require payment to an external company. Does anyone have…
Benny Barki
  • 11
  • 1
1
vote
1 answer

Cannot find type definition file for 'request': ERROR in node_modules/@looker/sdk-rtl/lib/oauthSession.d.ts:1:23 - error TS2688

I am trying to integrate Looker Embedded Client SDK with angular so installed @looker/SDK and configured setting as per guideline provided on official npm page for @looker/sdk to access APIs. But when I tried to access a few methods and classes the…
Mr. Raj Kale
  • 87
  • 1
  • 1
  • 7
1
vote
1 answer

How to count state changes by date in Looker?

I have a tasks in BigQuery with created date and last modified date. I would like to be able to report the number of task open and task close events by date in the same table if possible. view: tasks { derived_table: { sql: SELECT * …
CSJCampbell
  • 2,025
  • 15
  • 19
1
vote
2 answers

SQL - How to select the latest date of every month?

I have data set that looks something like this: |---------------------|------------------|------------------| | ID | Date | Cost | |---------------------|------------------|------------------| | 1 …
Mackay Young
  • 11
  • 4
1
vote
0 answers

Looker: Run queries only when the dashboard window in visible

We have a looker dashboard that reloads all of the tiles automatically every 5 mins. But this tends to be left open in the background and triggers a lot of queries which runs without purpose, is there a way to run the queries only when the tab or…
Somasundaram Sekar
  • 5,244
  • 6
  • 43
  • 85
1
vote
0 answers

How to sort pivot based on measure and create a stacked bar chart

I am trying to create a stacked bar chart between 2 dimensions (one being week, other is a string - more below) and 1 measure. I am new to Looker. But in order to get the stacked bar chart I figure that I need to Create a pivot Transpose the…
cyborg
  • 431
  • 1
  • 6
  • 20
1
vote
0 answers

downloading blank pdf when using express to call looker api

When calling render_task_results(render_task_id) looker API from my NodeJS based API using axios I am getting the binary data but when downloading it it is giving me blank PDF. PFB my code. const response = await createPdf(TaskID,…
Ashish
  • 11
  • 3
1
vote
0 answers

API Call within Laravel Controller

Is there a way to make an API call within a Laravel controller? so far I've been doing this w/out luck. I really appreciate any help. I'm using Laravel 6.
Mauricio Montoya
  • 13
  • 3
1
vote
0 answers

Looker Unit Testing value in developmentg against a value in development

I would like to write a unit test that checks whether a value in the development environment matched the value in production in Looker. At the moment I can check values against a static hardcoded value, but not able to check dynamically test:…
Mushirih
  • 451
  • 5
  • 13
1 2 3
…
13 14