This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I want to write a dimension with adding text values and date with MM/DD/YYYY format eg: Result for: 2022/11/05 dimension: resultfor { type: string sql: ...
I want to write a dimension with adding text values and date with MM/DD/YYYY format eg: Result for: 2022/11/05 dimension: resultfor { type: string sql: &...
Hi Looker team, Database Dialect: BigQuery Context: We build the SQL-based derived tables. In the SQL, there are some liquid syntax involved. For example: {% parameter ghp_trade.CME_ope...
Hi everyone, lately I am finding an issue that im not sure if its an expected behaviour, but its uncomfortable: while in development mode (before deploying to production) I set up the connection wit...
Hi everyone, When I work in my enviroment, I'm able, from the development enviroment, to select "Generate LookML from database", so I will get views/dimensions/etc for each table within the dat...
Hi All, I've implemented the "Join Paths" model design described in Fabio's "A Cure For the one_to_many Blues" article in some of my explores and it's working brilliantly for the most par...
Here I share something that could be useful for some customers.
Usually, when we apply a filter without values, works as the filter is not applied at all, querying all the values. But if we want to...
Hi, What are various way to give different names for one dimension. Dimension X have a label "nameA" I want nameB or nameC. Dimension: X { label: "nameA" type: string sql: ${TABLE}....
Hi all, I want to change query by typing in dashboard level. Like There's some filter window in dashboard. And let's assume LookML is written like this (Of course it doesn't actually work....