Questions tagged [lookml]
9 questions
2
votes
1 answer
Looker will not accept double single quotes for passed condition
When passing a filter from an Explore like in the below example for whatever reason we cannot get it to provide double single quotes in the query condition.
In the query inside the view has the condition that pulls the submitted value:
As you can…
Mike - SMT
- 14,784
- 4
- 35
- 79
1
vote
1 answer
Cache a Looker Dashboard in background?
I have the following problem: we have a few dashboards in Looker that we use for customer presentations. One of them takes 5 minutes to load if not cached before. I would like this dashboard to be automatically cached by Looker in the background, so…
jlshns
- 21
- 3
0
votes
1 answer
how can i set a constant in lookml (model + a few views) via git's ci/cd (or any other solution for dev/prod stuff)
I've got two databases in google bigquery: company.prod.db and company.stg.db I want to have a dashboard that my stakeholders can see the prod data, while I edit stuff in the dev side. So my lookml dashboards can pull data, and I can even update the…
Mohammad Athar
- 1,953
- 1
- 15
- 31
0
votes
1 answer
Looker measure to average over last 3 years
I am trying to create a measure (LookML) that gives the average of funding over a three year window.
A sample of my data looks like…
dalek_fred
- 153
- 10
0
votes
0 answers
Looker Categorical Statistics
I have to generate a report of invoices in Looker. Each invoice belongs to a category field. I am tasked with computing statistics of that category, and comparing each individual invoice against that statistic.
Here is an example. Suppose invoice 0…
0
votes
0 answers
Change values for CSS on Looker elements
From the option 'table' in the visualization tab I'd like to change the values for the css styles of the table (NOT THE RESULTS). More specifically I'd love to prevent the change to 'gray' on the hover at a level.
I tried to add some HTML inside a…
0
votes
0 answers
Looker Explore - display only latest day, unless date dimension is added
In a Looker Explore, we want to display only the data from the latest date for each ID. For example:
ID
Probability
1
0%
2
50%
When we add in the date dimension, then we want to break it down by date:
Date
ID
Probability
Feb 5,…
Milka
- 297
- 2
- 11
0
votes
1 answer
How to convert Cognos query to SQL query
I was working on Looker and I have to copy this Cognos query to Looker but apparently the SQL parameter on Looker did not work. I am not familiar with Cognos so I don't know how to solve this problem.enter image description here
I tried PARTITION…
