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.
Hello! I’ve been working in Looker trying for at least an hour to try to cast this string format (in a table column in Big Query) 2023-01-06T00:00:00.000Z to a timestamp. I found examples...
I have the data like this- date| product| price I want to plot the prices of the products datewise on a linechart. However, I have 3 products and I want a separate line for each product i.e. 3 lin...
Hi all, How to resolve this use case. I have two dimensions Y et Y and I want to create a new dimension Z who display columnA with the condition of ${TABLE}.columnB=1. Dimension:...
Hi, I’m able to apply conditional format for empty values but I could not able to apply the conditional format for NULL values. Can you please help me out on how to implement this. Question: NULL...
I would like to be able to render html inside a popup window Here is my dimension: dimension: view_HTML { sql: 'https://somedomain.com/123456.html' ;; html: <a target="_blank" href="{...
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....
...ata. I also tried changing conditional_formatting_include_nulls: true , but I also found it did not work. I am new to looker so I may have done some of the above incorrectly. Thank you for the h...
I am trying to build a tile for a dashboard that inherits a region dimension from the filter. Basically, the tile needs to show: - All products that have $0 spend in the region from the fil...
Hi all! I have a dashboard with some information on a grid (Project info); my goal is to click on a value in a particular column of the grid (Project ID = 1) and have Looker opening a new tab with t...
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_where condition of existing view that has transaction date. For Example: We have ...