Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Hi, I’m trying to create a simple parameter to choose between 2 dimensions to breakdown a view. I’ve copied the syntax exactly from the Looker docs, but keep getting an error saying that the “parameter’ needs a field name: parameter: regiondrilldown { type: unquoted allowed_value: {value: "Country"} allowed_value: {value: "State"} allowed_value: {value: "City"} } dimension: geo_breakdown { type: string label_from_parameter: regiondrilldown sql: case when {% parameter ${regiondrilldown} %} = 'Country' Then ${country} when {% parameter ${regiondrilldown} %} = 'State' then ${state} when {% parameter ${regiondrilldown} %} = 'City' then ${city} end ;; }
ContextI have two views - `call_speed_of_answer.view` and `call_abandonment_rate.view`. They extend a `call_base.view` which defines all the dimensions and measures used in the two views.In the `call_speed_of_answer` and `call_abandonment_rate` views, I set the `sql:` parameters for measures from the base view to define the custom logic for each’s calculations of `passing`.QuestionThe two call views have the exact same list of dimensions and measures. I want to combine the results back into one single result query, like this:Customer Measure Target Actual Customer_A Speed of Answer 75% 82% Customer_A Abandonment Rate 5% 3% Customer_B Speed of Answer 80% 79% Right now, I have the two call views as their own Explores. How can I union the results of the two views back into one single view? Are there other LookML options besides a third derived table view that manually UNIONs the results together via SQL? Is there a different way to extend the base view with cu
Has anyone else had issues with HTML rendering differently in the new dashboard experience? The spacing looks totally different from how it appears in our legacy dashboards. The example below shows the exact same tile in legacy vs new for version 21.6.39. The divs and line breaks get so much additional spacing that the tabs are no longer visible. Curious if anyone has a fix for this before I start redoing all of our HTML parameters. Legacy Dashboard:New Dashboard:
I’d like to make my single value visualizations bigger but there is no font or size feature in the settings. Can someone please help me? This is very easy to achieve with a couple of clicks in Tableau but in Looker it’s almost impossible. Any tips will be much appreciated.
I'm trying to make a tile in dashboard were value will be rendered through Look ML html via a single value vis,Where the if the length of the name is longer it's not warping,In ideal case should warp but it's going outside of the title.
Hi,I’m having difficulty formatting HTML in a text tile. I want to create a set of definitions in the form of a table, which is not located in our dataset. I first tried the very limited table format for a text tile in Looker, but it didn’t really let me do much in terms of formatting the text.I then went to use HTML format, and I am having difficulty actually making a table, with lines in between each cell (i.e. border-collapse). This is what I have so far, and I just want the same border on the outside, to be also the borders between each cell.<table style=" text-align: center; font-size: 16px; padding: 2em 3em; border-collapse: collapse; border-style: solid; border-color: #073763; border-width: 0.3em; background-color: #f1f1f1; margin: 5em;"> <tbody> <tr style="text-align: center;"> <th>Header</th> <th>Header2</th> </tr> <tr> </tr> <tr> <td style="text-align: center;"> <strong>title1</
In attempting to create an explore in my model file, I get the error message: There is already an “explore” named “new_explore1” Code that generates the errorexplore: new_explore1 {} Is there a place to view all existing explore in the Looker interface?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
