Dashboards & looks
Building reports & visualizations in Looker
- 1,913 Topics
- 4,334 Replies
Filter is applied to Tile after edit even if switched off from filters
I have a dashboard with bunch of single value tiles that are connected to a city filter. Then I have a column bar chart, which I want to be excluded from the filter. Unfortunately every time I go to the bar chart and even change the title, it’s connected again to the filters. Almost as if filters “attach” the on/off toggle to a name of the tile not its ID or something. It gets really annoying that I have to go edit the filters every time I make a change to the tile.
Mixed type visualisation - can't change settings for each series
If I use two series one as Column Bar and one as Line, I’m losing ability to change particular type’s settings. For example if the main icon on Visualisation bar is selected as Column Bar, I won’t be able to change the interpolation of the line chart.
Hide Value Labels from a calculated Measure
Hi, Community! I have my first question, hopefully we can sort it out together. I have my daily sales and I have a calculation with the average value of sales in the last 30 days. I want to visualise these two, as a line chart shown as area. Everything looks fine, until I want to show the Value Labels for the Sales line. I can’t find an option to show the Labels only for the Sales and keep the Average just as a line. It keeps showing on every point and looks awful. Adding a Reference Line does not work either, as I need the area below the Average to be coloured (say, in blue) while the area of Sales to be yellow, so we see in this way when we are ‘under’ or ‘over the surface’. Hope that makes sense as an explanation of my issue. Thanks for your time & help!
Drill to explicit LookML dashboard without enabling lab feature?
Hi there, I’m trying to figure out how I might enable my users to drill to a specific LookML dashboard from a measure without enabling the “drill to dashboards” lab feature (I suspect that enabling this feature would have unintended consequences in our deployments for various reasons). I thought I could probably do this with the link parameter but I haven’t been able to emulate the visual experience of a Looker dashboard drill (the “drilled” content is contained in a modal). Is there a way to do this though drill_fields and the link parameter? Being able to drill to the dashboard versus an adhoc rendered visualization would really help in this particular context. Thank you.
'Cancel' on Edit Filters on dashboard still saves changes
Hi, Just wondering if anyone has experienced this and/or if this is a bug. I have noticed that if I make changes to dashboard filters but hit “cancel” instead of “Save”, it still saves the changes. See GIF below: In case you can’t follow the GIF, I have a filter called “My Filter”. When I edit the filters and change the name to “My Filter (editing)” and click “CANCEL”, I get the prompt saying “You have unsaved changed. Are you sure you want to close this modal?” After hitting “OK” to discard the changes, you can see that the filter is saved anyway as “My Filter (editing)”. I’m wondering if this is a bug? It’s annoying when you accidentally make changes and try to escape out of them, but it still saves…
How to sum the values of a column based on value in another column
Hi, I have a column named project name and another column named allocation % I want to sum up the allocations for each project. Currently there are multiple rows for each project with different allocation %. How do i do that and show only one row per project?
Dimension for Table Calculation Subtotals
I am trying to create a bar chart. I have two dimensions, one is a parent (this is the dimension I’d like in the visualization), and a child (this is how the calculations are made in the table). The subtotals at the parent dimension are incorrect so I used this work around to create my own subtotals https://help.looker.com/hc/en-us/articles/360023635234 . Now I am trying to show the row that has the subtotal value, but at the parent level. If I hide the child dimension, Looker automatically takes the total of the calculation column. If I show the child item in the visualization and hide the parent, I get the correct information for the calculated column, but then it looks like that is the total for the child item. Is there a custom dimension I can create to work around this issue?
How to adjust the date/timestamp filter in Dashboard
Hi, I am trying to display only those records as result in looker dashboard in which my date is ‘2020-05-05 00:00:00.00’ from DB but i am getting result for where date is ‘2020-05-05 01:32:18.00’. I have filter the date field. I want result only for ‘2020-05-05 00:00:00.00’. Thank you
Percentage of Total - in a Tree Map and on a Bar Chart?
Hi all! A quick question here that I can’t find the solution of… I have the number of orders per country. I want to visualise the % of the total number of orders, for every country. Whatever I do, I only get the number, not % of total. I hope it would be possible without additional calcs, as this is quite a simple thing to do? The perfect case would be showing it both in a tree map visualisation, as well as on a bar chart visualisation. Anyways, even only one of these would help. Thank you in advance!
Stacked bar chart - value label when 0.00
I am not entirely sure if this is how the engine should behave. I have one measure stacked on top of the other but sometimes it’s 0.00. I want to show labels but label for 0.00 is not necessary and by default it’s white, hence it looks like following: As a workaround I neet to wrap my whole Table Calculation in another if statement to reutrn NULL if the value is 0. I think we could use a setting Treat zeros like NULLs in the visualisation tab.
"Show Full Field Name" not formatted correctly in Map Visualisations
Hi, In visualisations with “Show Full Field Name” on, we expect: View Name - Field Name With “Show Full Field Name” off, we expect: Field Name In the past, I remember it used to not be bold, i.e.: Field Name In map visualisations, the field name is still not bold. This seems like a very minor issue, but unfortunately it renders the tooltips drawn in Map Visualisations completely unreadable: We use this kind of chart a lot, so I wonder if this might be something that could be easily fixed…? Thanks 🙂 Euan
Fixing color of line chart with dynamic data
I have a line chart with 6 lines… The first 3 corresponds to top 3 product by sales on a day and the other corresponds to bottom 3 products by sales on a day. There are 32 products that I have. So the data is dynamic and the line charts will change everyday corresponding to which product is on top sales that day. I want to fix the color of the lines, say whichever product is in top 3, their color will always be red, yellow and green forever … How should we do that
System Activity - details click shows Visualisation tab empty
I’m not really sure what’s happening here. When using drill fields instead of seeing a table I’m seeing a new Visualisation tab but it’s empty. Then I click on Table and it’s empty. I basically have to close the drill fields window and open it again, and then it comes back with details. First click Close and open again Also the Visualisation and Table is gone
Selectively Hide Value Labels from a Visualization with "transparent" Color
The “transparent” color in Looker can be used to hide many different elements of a visualization. One useful way to use this color is to selectively hide value labels. Currently, in Looker, the value label setting operates on all value labels; it’s not possible to apply labels to specific series. Fortunately, it’s very easy to work around this by using the transparent color in the ‘Series Colors’ option. (Sneak Peek! We will soon be introducing additional visualization settings that will make this method unnecessary. Keep an eye on those release notes!) Here’s the result set I’m going to work with: In the image below, I’ve toggled on ‘Value Labels’ and ‘Totals Labels’. I’d like to hide the value label for the green ‘Yes’ series but keep the others. The input to ‘Value Colors’ corresponds to the series in the order that they are listed in the legend. By using white, transparent in the ‘Value Colors’ setting, I’ve hidden the ‘Yes’ series.
Adding link from dimension to scheduled Look sent through email
Hi, I have a scheduled Look that is sent through email to users. It’s a normal list. One of the dimensions in the list has a link to a dashboard (clicking on the link opens a filtered dashboard with the value in the dimension). This works fine when exploring the data in Looker but when I schedule the Look this link is not added to the dimension. The email received has the list but the dimension is not converted to a link. Is there any way of doing this? Maybe using the HTML tag in the dimension? Any suggestions? Cheers, Cristian
Time component on filter disappears when converting to dashboard-next
Hi all, I have a working dashboard with a filter based on a timestamp field. This works fine - there’re date and time components in the filter. When I change the dashboard to “dashboard-next” the time component disappears from the filter. What am I missing here? Any ideas? Cheers, Cris
Filter suggestions are not sort based on order_by_field in 4.18
Hi, we recently upgradedfrom 4.14 to 4.18 and one diference that I observed is as below. We have filter suggestion (where suggest_dimension is order by other dimension to have suggestions in desc order). It was working fine in 4.14 but in 4.18 it’s not working so regardless of the order_by_field Looker is ordering suggestions in alphabetical order and only 100 suggestions are diplsyiang against 500 for 4.14. Anything change in 4.18 which is not describe in the release or did this issue got fixed in 4.20? As we have to decide whether to upgrade to 4.18 or not?
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.