Questions tagged [looker]
Use this tag for questions concerning use of the Looker platform or its modeling language, LookML.
looker
287
questions
0
votes
0
answers
13
views
Rendering markdown content within Looker text box
I am trying to build a report in Looker, where one column happens to have text content in markdown file format. For example consider a 'student' table with below contents:
| id | name | notes ...
0
votes
0
answers
9
views
I need a calculated field for button clicks/views in Looker Studio. Is there a way around the inability to mix dimensions and metrics?
I am trying to establish conversion rate for a page with the general equation button clicks/views. Since a filter reading "Event Name = "button_click" would filter out views, I found ...
0
votes
1
answer
13
views
Can I change the names of the column headers in my look?
If you look at this screenshot, you can see the "repetition" of the header names. "Company Id Company Id" etc...
This is the LookML for company id dimension:
dimension: ...
0
votes
1
answer
21
views
DW/ BI dimension modelling, combining facts
I have read the DW/BI kimball design v3, everything seems logical to me, but there is one point I am struggling with. I work for a streaming company (OTT). We have different star schemas for business ...
0
votes
0
answers
16
views
Looker Pro upgrade
I am trying to create a Looker dashboard as part of a project on GCP but I am getting an error that I don't have permission to access the dashboard even though I am the super admin and I am using a ...
0
votes
0
answers
11
views
How to prevent link from open in a new tab?
I embedded my Looker Studio dashboard to my website using iframe. On my Dashboard, I have several links, that linked to other Looker Studio Reports. How do I preserve the iframe (Parent frame URL) and ...
0
votes
0
answers
7
views
"How is the field_selection_filter field passed? (API Looker Update an Alert)
I am trying to make a change to a Looker alert via API, but I am encountering the following error:
PUT /alerts/49 (422: Unprocessable Entity) Seconds: 0.271
Body (325 bytes)
{
"message": &...
0
votes
0
answers
17
views
Looker : Avoiding code repetition in html parameters in views
I’m working on a looker project that uses legacy tables.
Each column is represented by a dimension in a view, and there is quite a lot of html formatting in each view.
A lot of the formatting logic in ...
0
votes
1
answer
30
views
Looker Studio: Filter one table based on the field of the selected item on another table
I have one set of data and it is structured like this in two separate columns.
Item - Category
Apple - Fruit
Banana - Fruit
Cat - Animal
Dog - Animal
Elephant - Animal
Fence - Yard
Garden ...
0
votes
0
answers
19
views
Logging into LookerStudio report embedded in webpage using a google service account
We need to programmatically embed a few looker studio reports in our Webpage/app for different users to see. But these users may not have a google login when they login to our app. So we thought of ...
0
votes
0
answers
14
views
Formatting last_viewed_at filter in Looker Python SDK
I'm struggling to filter dashboards by last_viewed_at using the Looker API. I want to retrieve dashboards viewed in the last two years. Here’s the basic code I’m using:
# looker_sdk==24.10.0
import ...
0
votes
0
answers
23
views
How to run Looker assertion for data quality tests? on non-imuable data
I'm currently working on a project where I need to validate data quality assertions in Looker.
The data is mirrored in a PostgreSQL database, and it changes frequently (at least once a day), which can ...
0
votes
0
answers
39
views
Looker Studio Error - Metric results might not be accurate when using Asset level dimensions
I have a Looker Studio dashboard that was working with no issue before. For the past few months it shows the following error:
Metric results might not be accurate when using Asset level dimensions. ...
0
votes
0
answers
55
views
I need to divide two columns sum() that require different a date range dimensions each
So I have two columns that I need to add up and divide. The problem is that each one requires a different date range dimension to sum and have the proper outcome, so the final division turns out ...
0
votes
0
answers
13
views
how to export datasource from looker to azure adls gen 2 storage cloud
is any way to migrate the data from looker to azure adls gen 2 cloud storage.
I can see only export the data to google drive / email options to export the data. kindly let me know is any way to ...