Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
@fabio @izzy https://lookervisbuilder.com/ seems to be down at the moment - not sure if temporarily or permanently? Jim Rottinger isn’t at Google anymore - is that (awesome) tool still going to be maintained? thanks!
If I understand your question correctly this should be feasible if you pivot by your dimension “region” (not year), and display your measures as stacked bars with the “Grid Layout by Pivot” option
Hi both,Seems to me that you’re using layout grid in a LookML dashboard set to dashboards-next (the newer version of dashboards). Only one layout is supported in dashboards-next, as explained here.BestEliott
@n_davis sorry this might be a bit late but you just need to use target="_self" on your anchor tags (<a>)
Hi @eliott !! To confirm, you would like to select or configure the default visualization in the drill modal? @lauren.boltz yes that’s right. Currently the only visualisation that is displayed when a drill menu opens is a table (unless Visual Drilling is enabled, but this is not an option as I want to customise the drill menu from a Dashboard Next, and there is also no way to choose the visualisation presented).I’m wondering if we can overwrite the type of visualisation (e.g. a single value or a scatter plot) that is presented instead of the table in a drill menu specifically (not using ‘link’, in which I know we can customise the visualisation but this opens a new page or dashboard)? Thanks!
@lauren.boltz Is it possible to configure the default visualisation on the drill_field modal directly? I.e. not by setting a link parameter, but instructing Looker which default visualisation to show in the drill modal directly. Thank you!
Hi Jharna,To my knowledge we’re not able to dynamically hide/display visualisation tiles on dashboards. You can set parameters to show NULL or no results, but the tiles will still be there.Your best bet is to create a dashboard using Looker API or Looker Embed and dynamically hide or display your visualisations with Javascript.
Same here. I have a left and a right Y axis and the reference line (type “line” and with value “custom”) always positions the line based on the units of the right axis.
Have you tried using a regular CASE statement in your SQL parameter? Something like: dimension: product_description { type: string sql: CASE WHEN ${product_sku_dimension} = “abc123” THEN "abc" WHEN ${product_sku_dimension} = “xyz789” THEN "xyz" ELSE "other" END ;; }
How would that work with a large table which has multiple nested records? Would this trick also work? Would we have to create NDTs for each outer nested tables as well or simply generating uuids in a dimension suffice? Thanks!
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.
