Dashboards & looks
Building reports & visualizations in Looker
- 1,823 Topics
- 4,251 Replies
Hi all, So I have a look that pulls data for product sales, the Look returns Product Name, Sales, and UPC numeric code. I have a google sheet that has Product Name, and UPC and turns the UPC into a barcode. Is there a way to download the look directly into the google sheet and map the columns so it prefills the data?as of now, I have to download the look then copy and paste the data into the sheet.
I have LookML definition that has 3 views, and explore model that joins all these views.Each view has some measures and the date column. Measures are not related to each other so there is no a single date value under any of views that relates to all measures.Table1:Date1 M1 (measure)Table2:Date2 M2 (measure)Table3:Date3 M3 (measure) I’m trying to create a pivot table e.g.:| Month1 | Month2 | ...| M1 | M2 | M3 | M1 | M2 | M3 |where Month1/Month2 are last 2 months, and all M1-M3 measures are calculated based on Date1-Date3 belonging to Month1/Month2 Ideally, the user to be able to choose the date range (monthly, weekly, last 3-6-12 months) Ideally, I don’t want to create a separate precalculated denormalized single view
Is there any way of utilizing the series_colors LookML parameter through the UI? The description found on https://help.looker.com/hc/en-us/articles/4420171149075-Column-chart-parameters-for-LookML-dashboards suggests that it could be used as a form of conditional formatting for fields in a column chart. It seems though that without saving off a dashboard LookML file and manually applying the settings it is not available to be utilized. Is there any way of either exposing this in the UI or repurposing the conditional formatting functionality of other visualizations to apply these parameter settings?
How to set a transaction date filer that's dynamic. 7 day span - 1 year ago, starting one day later. EX: (Week of 4.11.22, compared to week of 4.12.21)
Hey guys, I’m trying to set up a dynamic time filter for transactions, but cannot find the appropriate way to express it. I need to compare a week from this year, to last year, with a starting date difference of 1 day. EX: Week of 4.11.22 (mon-sun), compared to 4.12.22 (mon-sun)So 1 year ago, plus 1 day, range of 7 days from there. This would allow me to schedule a report with this years information, as well as the relevant LY data to compare it with. Anywhere I can start? I’m not all that savvy, but figure once i have it set I’ll be golden.
Hello I have a question about having filters affect the results you see in other filters inside of Looker. So far I’ve been trying without success, but in short, I am trying to do the following: I have the following hierarchy chart:It starts with the three teams at the top - this would ideally be the first filter, with those three options.However - if I choose Product Team - Filter 2 should only show Product Manager 1 and Product Manager 2 - it should not show the other positions at that level.And the same logic for filter 3. I would first select Product Team, then I could select Product Manager 1, and then I would have the choice of Product Invididual 1 or 2 in Filter 3. Is this possible to do inside of Looker? Right now, when I select Product team and go to Filter 2 - I can still see all the Engineering Manager roles. And - this has been abstracted - in the real case, there would be a 20+ options at Filter 1, 100+ at level Filter 2 (before it is filtered by Filter 1), and 1000+ at le
Looker documentation says "you can set the color of map points or define the range of colors to be used if you are color coding according to a measure."How can I color the points on a map based on a dimension? For example suppose I have a dimension called “places”. Inside that dimension there are 3 types of places: cafe, libraries, and schools.How can I plot the points so that the cafes are blue, libraries are green, and schools are orange?
If a user schedules a Dashboard with the format option CSV zip file, the schedule errors with message: Error message: format format txt invalid -- valid formats for Dashboard sent as 'looker-integration://2::Email' are [:csv_zip, :wysiwyg_pdf, :assembled_pdf, :wysiwyg_png] (code: invalid)I can’t find any documentation anywhere regarding this error.
I have 25 looks created from an explore. now i want to create 5 dashboards for different level of people in the organization eg for manager, sub manager etc rolessome of the looks need to show to multiple roles like some look need to show to manager and submanagers as well . I tried create 5 different folder for each dashboard .But here same look i need to duplicate to different folder in order to use the look for specific folder dashboard and in future if any change i need to do in the look I will have to do it in all the folder and i want to avoid that . So asking for different approach . Here user_attribute wont work as all looks are coming from same explore
Hey guys! As the title suggests, our team is struggling to find an easy and maintainable way of communicating with our data viewers regarding dashboard filters and the specific tiles they update. We have dashboards where certain filters only affect a few tiles, but not all of them, and we don’t have a good way of specifying which filters affect which tiles. So far, our only solution has been adding the text (All) and (Limited) at the end of the name of each filter to specify whether they apply to all tiles or a limited amount of them. We have also thought of adding notes to each tile specifying which filters affect them, but that is really hard to maintain. I would love to get some ideas from the community on how you are dealing with this issue. Are there better ways to tell our users what tiles are affected by each dashboard filter?Thanks!
Already have an account? Login
Login to the community
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.