Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
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
There is a scheduled look report, created by my coworker, that no one but her seems to be able to edit. Neither of us are admins, and even and admin on the team can’t edit or change the original schedule. This seems to be a bug, as he hasn’t had problems editing schedules as an admin on other reports. The look is in a communal space, and not on anyone’s dashboard. Is there some permissioning that we are missing that would account for this?
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
Hi, We get spend data from our channel partners daily and ingest into looker. Sometimes the data doesn’t flow as expected. I would like to create an alert for each channel. Eg. alert me if daily spend for partner X is below average +/- 3% spend for last 7 days. Thanks, SS
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
Hi everybody, I’m new to Looker, and I’m trying to understand if I can create a simple table to compare yesterday (it was a Wednesday) to the average of the previous 4 or 6 Wednesdays of this year. I’ll try to explain my request better: we receive daily a certain number of leads, but usually they’re not equally distributed during the week, so for instance usually on Monday and Tuesday there are more leads, while on Wednesday it’s less, and so on. So I’d like to have a table with 2 columns: yesterday, and the last n days that are the same day of the week to understand how yesterday went, so I can immediately spot if it’s a normal trend or if it’something that is worth more analysis. Thanks a lot Giovanni
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
Not sure if this is the right category to post in… I’d love to connect with someone who has worked with SaaS data in Looker (preferably SaaS data from Recurly). I’m trying to figure out some best practices for working with SaaS data. There are bunch of posts online talking about what to look at but few talk about how. The key challenge is that most SaaS data is stored as the current subscriber state. From an analytics perspective, you’d want to know subscriber states at various points of their billing cycle + the events that happened in each cycle (state changes, expansion, contraction etc.). Curious to know if anyone has gone through the exercise of converting subscriber state data into something more meaningful that’s useful for analysis? How did you architect it? What are some of the challenges in that process? Here’s an example of one of the challenges I’m trying to solve: I have the data about when the subscriber activated + all adjustments that were made to the subscriber account
We set up an Explore with two dimension (one as rows, one as columns/pivot) and one measure. When the output is being shown in Looker, we see multiple rows for one and the same element of the dimension: This is some very unexpected behaviour that also leads to error messages (“Unable to chart pivoted data when dimension Marketing Controlling Partner has repeated values. This commonly happens when you create a query with a second dimension and hide that dimension from the chart.”). That’s the SQL that Looker creates: SELECT * FROM ( SELECT *, DENSE_RANK() OVER (ORDER BY z___min_rank) as z___pivot_row_rank, RANK() OVER (PARTITION BY z__pivot_col_rank ORDER BY z___min_rank) as z__pivot_col_ordering FROM ( SELECT *, MIN(z___rank) OVER (PARTITION BY "marketing_controlling.partner") as z___min_rank FROM ( SELECT *, RANK() OVER (ORDER BY "marketing_controlling.partner" ASC, z__pivot_col_rank) AS z___rank FROM ( SELECT *, DENSE_RANK() OVER (ORDER BY "marketing_controlling.date_month" NULLS LA
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!!
This feature request appears to only apply to the embed iframe. This feature already exists in the non-embed Looker UI. When exploring (new tile > explore), actions menus denoted by the ‘…’ will not open. There are many use-cases that support this menu opening in the explore window. This feature is only accessible after clicking “Explore from Here” in the exploration window, which adds unnecessary steps to the user’s workflow. This context menu should open in the original exploration window. Here is an example of this workflow. https://www.screencast.com/t/7rrqbHaJDNv
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?
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.