Dashboards & looks
Building reports & visualizations in Looker
- 1,689 Topics
- 4,117 Replies
I understand that Table-Next is being actively worked on by the Looker team (I hope). There’s still basic functionality missing though. Maybe I’m crazy, but we still don’t have the option to wrap text within columns, right? As a result, it’s been pretty difficult to get buy in from our business team, who looks at a lot of freeform text. Any insight from the Looker team on what features are being prioritized here? It feels like this thing has been live for two years, without material improvements. The older threads are closed, so I had to start a new one on this topic.
Hi, I have some data with Date, Product type (chairs, tables), Customer Name, Order Sum From this I want to create a view that shows:Date - Category - Top Customer based on order sum July 2022 - Chairs - Bob July 2022 - Tables - TheresaJuly 2022 - Carpets - Mary June 2022 - Chairs - LenaJune 2022 - Tables - Theresa … One customer can be present in many or all categories, but no order mixes categories. I.e. its always only chairs, or tables or whatever. Im semi new to looker but what I was hoping to do was something likeCase(when (order=max(order), Customer name)) This doesnt work however because it only returns the name for one row, the largest order across all categories. Very thankful for any help or guidance! Thank you
Hi Community, I just want to express here my frustration on how Looker decides what capabilities to deliver next. We have now the possibility to do Forecasting with ARIMA models but still not out of the box PoP and grouping for others? For PoP we have to follow very complicated approaches and for grouping in “others” not very scalable solutions (table calculations and rankings). I was wondering if we can see the voting for new product ideas
Hi! We currently have a dashboard that gets notes written on most tiles each week. Each week that dashboard and all the notes are sent out to particular stakeholders so the information is saved. The problem: When comments go beyond a particular size, if the tile itself isn’t resized then those comments will be cut in the schedule. Is this a problem anyone else has had? If so, what have been your solutions? Our current method is to just resize the tiles if the comments are a bit too long, but would like to avoid any manual process here. Thanks!
Within a Look when clicking the Explore from here, there is a 5 - 15 second delay before the Explore page renders. After clicking, from a user perspective it just looks like nothing is happening and that the click did not work. Using ctrl+alt+E opens the Explore immediately but that is not a good user experience. Has this been reported? I do not see anything in the community documentation.
I am new to Looker.I have a partitioned BigQuery connection to Looker.Due to this there is a required date filter on any query demanded, which prevents the source query for suggestions from functioning.At first I found a work around by using a ‘sql_always_where’ in the explore, but then realized this was generating queries over all the data (which is big) to get suggestions.I recently developed a dashboard from a derived query. At first I hard coded a where condition for the date field limiting it to the past few days, however, the final data would need to be at any time period in history. When I adjusted this date to the data start I realized it was very expensive to run. It needs to be run with different filters by different people so caching/persisting isn’t really an option.To prevent the derived table query from querying over all the data, I followed the ‘Creating dynamic SQL derived tables with LookML and Liquid’ Lab to inject the dates into the derived query. While this works fo
So I have a cumulative bar graph containing a total number of patients from Jan-March, in a singular bar though. How can I edit it so the bar graph has three bars for Jan, Feb, March. Instead of just one bar that includes all of those 3 months.
Hi, I want to draw a graph displaying the evolution of a ratio. I manage to do what I want : However, the ratio is calculated by taking as a reference the value of the measure when rank=0 (that’s why the ratio is always 100% when rank=0) And the look is part of a dashboard. So if the user of the dashboard doesn’t select rank=0 in the filters, then the curve won’t be displayed I would like to “oblige” the user to select rank=0, but to be able to add other values of his choice (here 1 and 4) Is it possible to do so ? Or it there any other way to take rank=0 as a reference if it’s not part of the filter values ? Thank you ! Best, Flore
It’s quite possible I already mentioned this but I can’t find the thread. Look at this visualisation: There’s plenty of space for labels to show but somehow they are not. I need to make them twice as big for the engine to kindly decide to show the labels: It is very annoying as it prevents me from building dashboards with tiles that do not have to be as big as half the screen. This one is bar chart with grid 3 grids per row
Hi all When I want to show the age bracket in the dimension, it returns with a zero to slash for each age group. However, when I tried to set it as filter, it seems that the value can be read in this case. Does anyone knows what happen here?Thanks for the help in advance.
Hello, I want to create a single visualisation of a the total number of people that were active for a particular service in one week. The problem is that these value is a non-numeric value ( ID’s). How can I aggregate this, so I can have a total number which then appears on a single visualisation? I would also then need to calculate the percent change for every week.
We are upgrading our self hosted instance and noticed we are no longer able to schedule dashboards if any of the tiles fail to render. Previously this would send with an indicator that the broken tile failed to render, and now it just sends an email to the schedule owner that there was a failure. Is there a way to enable sending the parts that succeed?
The company that I'm working for is going to start using ServiceNow for its IT operations and call-center management and they are looking at its SDLC module for software project management. However, there is also a push (by me) for using JIRA+Greenhopper+Fisheye+Crucible.Has anyone out there done a feature by feature comparison of these two tools?Using the ServiceNow demo, it sounds like it's quite versatile but I believe it's being customized pretty heavily for our call-center by Service-Now, themselves.One of the biggest things that I've liked about JIRA is the extreme level of customization that we can do on our own and morph our processes as a result of our retrospectives. I'm not entirely confident that ServiceNow can provide that and I would definitely like to hear more.Some features that I'm wondering about in ServiceNow that I can accomplish with JIRA+Greenhopper: Sprints across multiple projects (Scrum Products in ServiceNow?) Source/Code Review integration like with Fisheye
It is common for our users to click and drag to select a range of data, copy and paste in an email / Slack.We have dashboards with cross-filtering enabled. When the users select a range of data, they are unable to copy. They claim that they have been able to copy before.Any idea if this was a recent change from Looker or a workaround to enable copy on a cross-filtered dashboard ?
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.