Aggregate counts
Hello, I’m having trouble figuring out how to count publications in my data set by year and author. In my expl...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
creating looker account
How to create looker account for practice purpose
2 databases/connections in 1 project
Hi, I was wondering if it is possible to have 2 models that each have a connection to a different database in ...
2 different connections 1 model multiple views
I tried checking in other posts and I couldn’t accomplish joining data from 2 different connection. I have a c...
measurement conversion
I'm new using looker and I wanted to know how to make this measurement from powerbi to lookerI need urgent hel...
html rendered_value in dimension not respecting date format
Not sure if it began today but I have the following set up for dates in my view:dimension: this_date { type: d...
Table Calculation
How can I count the number of instances in a column and then have it all on one visual Currently using sum fun...
How to set filter_config as range of date in sdk.run_inline_query
I try to set date range though sdk.run_inline_query. I guess I need to set the filter_config for date range an...
Using Data Action with Dimension Group
Does anyone know if it is possible to add a Data Action to a Dimension Group? My use case is that I need to at...
The project mysteriously vanishes
Hi Team,The project mysteriously vanishes while developing LookML dashboards; now, I can only access that spec...
PDT rebuilding every hour due to 'table not in scratch schema'
Hello,I have a problem with several persisted derived tables that are set to rebuild overnight, but are actual...
seconds to days, hours, minutes and seconds
How to format duration which is there in seconds to days, hours ,minutes and seconds .ex: duration : 3601o/p :...
How to count average WITH zeros in LookML?
Hello! I didn’t find anything like this in other topics, but I really need to count average with zeros. F.ex. ...
Creating if statement to get the time in-between two dates, but if the need by date is NULL then I want to use The create date
I have this so far. I want to find the number of days between the need by date and the receipt date, but if th...
How to add Average to a table like Totals
Hi! I am trying to do something in Looker that seems like it should be simple. I know there is the check box, ...
find looks that use a specific dimension
We are changing the definition of a particular dimension in our model. We’d like to see a list of all impacted...
Dias uteis
qual a melhor forma de calcular dias uteis entre data.
Filter default selection based on user
Hello,We have a dashboard where we are in need of a default selection in filter based on the user. The user ca...
Google analytics GA4 Block LookML error
I have connected GA4 block and setup the connection successfully , most of the dashboards are working fine exc...
Error Creating Indexes for PDT
I’m using a PDT in my application. I get a warning that I’m not using an index for my PDT, and so to commit my...
Errors with Setting Default Time Filters
I have an application where I want users to be able to filter their data by time on a dashboard, and I want to...
Can you change what Looker reads as the current date?
I’m working with date filters where I need to be able to create a period selected filter where users will be a...
How can I create a calculated measure with fields that are located in different tables ?
Hello, I’m trying to create a calculated measure in a payment table, the calculation is very simple, I need to...
How can I print out a string if a date listed is within a specific range?
I want to print out “June 2022” if the date range is like “2022-06%”, but apparently you cannot use ‘like’ wit...
Incremental PDT not working in dev environment - Looker
Hi Team,I am working on development environment in development mode.I have created Persistent derived table bu...
Push to Remote not working
Unable to Commit changes / push changes to remote since past few days.Currently I open the project in git to m...
Ask Looker initial configuration
Hi Team,We have installed ask-looker from marketplace and trying to configure it for a POC.First step after in...
How to Change the Date format to Sep - 2022
I copied and pasted the code into my LookML from this support page and put in my timestamp field. It does not ...
Datagroups Deleted Overnight
Hi, it looks like our Datagroups were deleted overnight. Anyone else experiencing this? Also it seems like our...
How to best design for unique users count
Hi, Trying my luck with a new topic as I have not found anything yet. We have daily aggregated data with certa...
