Dashboards & looks
Building reports & visualizations in Looker
- 1,560 Topics
- 3,978 Replies
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
Hi, I have noticed that a topojson that I am using for map_layer in Looker does not show correctly in interactive map. Some polygons are showing in conjunction with some random others as if the arc indices are mixed up. I validated my topojson by rendering it locally on d3 and it looked fine. Has anyone else experienced something similar?
Hi, We are trying to create a curated experience for our sales team inside of Looker. To do that we are using a Text Tile with embedded links as a navigation bar. The challenge is that for some reason the sub-title field cuts off what we can display in it. The weird part is that it works just fine when it’s first edited. Then once you reload the page it cuts most of it off. Is this a bug or a feature? Also - It would be great if Looker made it easy to create simple curated loops of dashboards so that very untechnical users would have an easier time getting around.
Hello, I have a dynamic filter on a dashboard, my problem is that it does not update my % change as a single number. When I click on the tile it is updated but from the dashboard it is not. I get the error: Missing values for ‘ticket.timeframes’ were not filled. The applied filters make it unclear what values to fill. (Dynamic Date Filter Comparisons) Could someone please advice how I can get my % change to show on the dashboard instead of no value? Thanks, Kind regards, Christine
Hello, I wanted to create more shades of colours, not pick one from the the palette but have several shades in one colour. Could some one please advice how to do that? Clarification: Having several HEX codes in one so the colour will not be uniform but blend with the other colours to create less contrast. Kind regards, Christine
Hello, When I add categories to my dynamic filter it is unreadable as there is no information indicating what the bars are, They are pivoted so I only have previous period and this period as label. Could someone please help how I can add names to my bars? Thanks in advance Christine
Hello, Please find below a few product wishes for your new release. Your chat informed me the following was not currently possible or sometimes possible with a long “workaround”. I thought I’d post them here so other users do not search for the same question. However, I tried to insert photos to better illustrate but received a message that as a new user I am only allowed one photo. Could you please kindly tell me when I may complete my post ? You can not have colours in bar charts unless you pivot, would be great to have a bar graph in colours that is not pivoted. Would like to be able to overlay bars like this: Have bar titles directly inside bars. Sort data when its pivoted have x axis name DIRECTLY under the bars instead of as legend. Thank you in advance Christine
EDIT: Sorted this out by reversing the role of the pivots and limiting the results to be 1 row only - it wasn’t exactly how I wanted it to look, but it will do. Let’s say I’ve joined a few tables, and I’m grouping them on orders by seller, while filtering on the date of which those orders were paid for. I would like to have the last 1 month of orders, alongside the last 12 months of orders, like so: https://imgur.com/7SHUKqb.jpg The problem I’m having is that I can’t figure out to apply separate filters to the monthly/annual columns. I tried pivoting around the date too, but there didn’t seem to be a way to group by month, and annual (only just purely monthly). I have also looked at putting a custom filter in LookML, inside the orders view, but I can’t put that in the contact view, as it doesn’t know about the orders paid date in there. I could do it as 2 separate tables, but ideally I want it in the same table - searching around the documentation, I saw that you can combine two tables
I’m just diving in to the world of custom visualizations. A few questions: Is it possible to link to css files from a custom visualization? Is it possible to share common code between multiple visualizations? For example, perhaps you have common functionality between 3 different types of bar charts that creates a y-axis. You don’t want to duplicate it in all 3 files. Can you reference a common function that creates a y-axis from various visualization files? Can we leverage Looker’s hovers in our custom visualizations? Rather than starting from scratch, I’d like to edit the existing column chart visualization that Looker provides. Where can I find the code Looker uses for its default visualizations?
I am building a look that tracks customer support tickets. Each ticket has three variables of interest: Created Date, Solved Date, and Points. I am looking to create a line graph with 2 lines - Points vs Created Date and Points vs Solved Date. It is easy to create these separately, but I can’t figure out how to combine them into one as it would need separate X axes. Despite both dimensions are dates, there doesn’t seem to be a way to have the X axis be a simple date, and then plot the two graphs on it based on the relevant dimension. Anyone have any thoughts?
Currently, Looker allows up to 50 entities to be displayed in the Pie Chart visualizations. The problem is, however, that if there are many entities, the data will either not display at all (in case there are more than 50 entities) or the displayed Pie Chart would be very cluttered (due to so many entities being squeezed into it), making it hard to review it. That could be solved if we could indicate the number of entities to be displayed and by putting all others under a slice of ‘Other’. For example, if there is a case with 70 entities and user wanted to display only the top 10 (this number should be adjustable), the resulting pie would consist of 11 slices (10 slices for top 10 entities and 11th slice for ‘Other’, where entities from 11 to 70 would be accumulated together). Looker already allows selecting the number of rows to be displayed in the Table visualization. Is this something that could be implemented on our side (we’re a subscribing business already) or something that you
I have Looker dashbaord created and have cache enabled at explore level for 6 hours. Issue is if I run dashbaord once and run same dashbaord again with option clear cache and refresh. When I or user run the same dashbaord again it is using old cache before clear cache and refresh option. How to make sure the Looker uses updated cache not the old cache. This is really critical as I did testeing for the data but when Looker delivered dashbaord to the users it delivered the old data. This is really frustating from our side as there is nothing that I can do even I know the issue is from Looker side. 😦
Hi there! I was wondering if anyone had any ideas on how to achieve per-report formatting. Team A in our company has very specific requirements regarding how null values should appear, which differ from team B. Ideally, I wouldn’t have to define “Dimension A - ‘NA’ as Null” and “Dimension A - “NO VALUE” as null” Thanks!!
Is anyone sending data from Looker to external visualization tools like Geckoboard? In my organization, we need to display certain high-level metrics like KPIs on an information radiator. We need these metrics to refresh automatically when the underlying data changes. We currently use Geckoboard, but its visualization options are quite limited. Visualization options like funnel charts are not available to be configured on Geckoboard. Are any of you Looker users/developers sending data from Looker to a tool like Geckoboard? How about another automatic information-radiator solution, with richer visualization options?
Hi There, My database has two tables (1) Item Table - Lookup table of all Items i.e jeans, shirts, T-Shirts , etc. it has fields as ID - integer - primary key Name - string (2) Sales Table - contains sales data for each item. it has fields as ID - integer - Primary Key ItemID - integer - foreign key to Item.ID *SalesAmt - numeric year - numeric Month - numeric I have created dimension as “Item Name” and measure as “Sales Amt” How do I (1) dynamically show measures in Explore as “Jeans Sales Amt” , “Tshirt Sales Amt” ? (2) Allow my user to calculate between these values. such as Sales Amt of Item Jeans Plus Sales Amt of Item Tshirt
Hi, Pie Charts seem to demonstrate this annoying characteristics that almost always ‘Label - Value’ is drawn beyond the Look’s visible area. (labels outside of visible area) . It seems impossible to show values in so many cases. When switching to Label Type = “Legend”, you can never see values, just percentages (Legend cannot show values, only percentages). Is there any option for Pie Charts to show ‘Values’ (not percentages) in legend ? Any chance to plot Label-Values Labels withing visible area of a look? Rgds, Matt
In scripting language data viz (e.g. ggplot2 in R), imagine I have a dataframe where each row represents a school, with three columns: school.type, which has 3 possible values: ‘elementary’ or ‘middle’ or ‘high’ school.name, each school’s name student.body.size, and integer count of enrolled students If I want to make a bar chart where the x axis lists the school names, the y axis is each school’s student body size, and I want each bar’s color to be selected from a palette of 3, based on its school.type, I can just set x, y, and colour parameters to school.name, student.body.size, and school.type variables respectively. In Looker this isn’t possible currently. In order for bars to be differently colored, they need to correspond to different columns, which I’m able to accomplish with some goofy pivoting, but it would be really nice to be able to set color to be based on a non-numeric column, like school.type here.
Hello, I have a look that shows recent calls to a single phone number, including call id, call start/end times, call reason, etc. I want the results of incoming call phone numbers to autopopulate a filter on a separate look on the same dashboard. Is there a way to do this? Thank you.
I’m trying to convert an user-defined dashboard into a lookml version to enable easier changes and updates of variables and filters that apply to multiple looks used in the dashboard. I’ve followed the steps in the documentation but when I try to launch the lookml dashboard I keep getting >>Element ‘XXX’ is already defined<<. Anyone know what is causing this? 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.