Dashboards & looks
Building reports & visualizations in Looker
- 1,843 Topics
- 4,279 Replies
Hi Looker team, We are seeing some odd behaviour with the bars on a table visualisation, see screenshot. Note in the first 2 columns the bars are not scaling correctly. In the first column row 3 we would expect the 0.4 value to be 40% width of the first row bar (as this is 1). How is this being scaled? Thanks, James
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.
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.
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!
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.
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…
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?
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?
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
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!
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.
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
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
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
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.
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
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
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.