Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
Map Visual Glitching on Looker dashboard
I am attempting to add a map visual to my dashboard. I have all the necessary information required to make a static map chart on Looker: geolocation data (as a dimension), state, postal code, customer name, customer ID, and billing city. When I pick the map option for the chart, it just does not plot anything. If I reload and try it again, it’ll plot orange dots in the locations but I can’t edit any aspect of the map afterwards (such as icon shape, color, etc). Then, if I add this map view to my dashboard it just comes up as a bright blue tile with nothing showing. Please help & TIA
Passing Parameter in SQL
Client has shared me a query using which I created a derived table and made few looks for a particular parameter hardcoded in query as where condition and embedded looks into their portal. Issue I am facing now is the query contains parameter hardcoded in query as where condition. But client wants dynamic looks in such a way that whenever a user tries to login into their portal using SSO the parameter based on user login must be applied as a filter and looks should be displayed accordingly.
Grouping in a table calculation
Is there a way where a dimension can be grouped within a look? Ideally a table calculation as eventually this will be used in LookML Dashboard. I’m really looking for a nested if then, but struggling with the Yes, No For example. If I have Dimension= A, Dimension = B and Dimension = C, then X. If Dimension= D, E or F, then Y Else Z
Check IDs in a list against one ID
Hi folks I want to be able check a list of IDs against one ID, specifically if all the IDs match the one ID, then yes, otherwise no. So, for example, a sales rep has an ID of 1234 - I want to know: do the sales rep IDs for the last 10 sales all match that one ID. Just to be clear, this is not just “are all the IDs identical” - I need to specifically check whether or not they all match any given ID. Ideally, this would be a custom dimension Many thanks in advance
Dashboard Difficult to Read When Printed
Hello all! We have recently been receiving a lot of feedback from the consumers of our dashboards/visualizations about difficulting reading them when they’re printed. I was hoping someone here had encountered the same issue, and if so, could shed some light on how you’ve worked around it. For context, we use Looker embedded into our proprietary SaaS platform. The customers that use our platform then have access to view a library of Dashboards and Looks that we’ve created for them. Oftentimes, they will consume these dashboards by receiving them on a schedule as a PDF. And in many of those cases, they will want to print them to bring with them to meetings/presentations, and to share internally within their organization. The concern that they’ve been bringing up is that the text on the dashboards is difficult to read. Now, the text they’re referencing is actually the text in text tiles and the titles text of visualization tiles, not in a single-value viz. Is there any customization to be
With new alert icon the ability to move tile is restricted
With the new alert icon, the icon to move a tile is not always visible… Sometimes my tiles are small and contain only one graph due to limitations in different places… that’s when it’s still visible a bit that’s when it’s covered those come from two different tiles with the same size - just to add to the weirdness
Looker 6.16 Alerting Use Case
Hello, I’m posting in a separate topic the discussion we started in the release note post for Looker 6.16 about an alerting use case. cf: Thanks @bens for your observation but in fact, I was not using any pivoted dimension in my data table. I made further test this morning and I noticed that if I replaced “Session Hour of Day” by “Session Hour” the alerting modal was working better with just one serie available instead of 24!! Seems that “Hour of Day” is not recognized as a time interval. cf But now, I would like to see how can I achieve my use case : ideally, I would like an alert to be triggered if my conversion rate drops below a certain threshold. Let’s say 50%. I have a doubt about “Changes by, increases or decrease by” : should we enter an absolute number or a variation rate? In my case, I have a conversion rate in the range of 0.5% so should I enter “Decreases by 50”? Finally, I assume it’s not yet possible in the current beta version of the Alerting, but it would be great t
Hello, Grouped Table view subtotals, sums related column disregarding the calculation of the measure. Revenue RR column is calculated by Net Revenue / Target Net Revenue which shows as 47% for the first column. However, in the subtotal area of the family, it is not calculated like that. Instead, it is the sum of all Revenue RR.
Loading drill-down data from an Iframe into a JS/React modal
Has anyone seen, or know of any examples where you can visually drill down using a dashboard URL, but open a secondary dashboard in a modal using JS events? Any insight would be greatly appreciated. Currently I can drill down on a dashboard, but the way the UI tab panels are structured in our React application, there is no way to go back in the UI except with the browsers back arrow. I would like for a JS event to trigger when the user clicks on the URL that goes to the secondary URL, but rather than embed that secondary dashboard view in the DOM, have the secondary view injected into a native modal. I’ve already whitelisted domains (following Looker’s docs and read all the Looker embedded JS events stuff).
Looking to compare the same measure across two different time periods in one explore
Hi All, I am looking to compare Junes sales vs May sales broken down by a dimension, but specifically having a new measure that returns the difference between the two measures. I have tried playing around with Table Calculations & the new create dimension/measure but I am not sure on the best way to approach this. I want to avoid using lookml if possible as it’s an ad-hoc view. Example of how I would want my end result to look Thanks
Displaying annotations in time-series visualizations
Hi, we would like to display time-based annotations in time series visualizations, e.g. show product or store launch dates associated with specific spikes in a line chart of sales over time. The closest parallel which I can think of is the annotations feature in Google Analytics (see attachment). For the purposes of this discussion thread, assume that we’ve already brought the annotations data into our data warehouse from which Looker is pulling (with a date-timestamp and a short text field). We’ve not yet actually done that because we haven’t known of a decent way to incorporate those annotations into visualizations. We’d appreciate any ideas for how we can do this! Thanks in advance for your time 🙂
Creating % of of Total by Line
I’m new to this software, so I apologize if this question is a bit simplistic, but I’m looking to create % of total for sales by line so I can look at XYZ product and see that its 10% of sales, or whatever the correct percentage is. I’m struggling with the correct syntax to create this calculations
Looker Export issues - last total value not showing up!
Hi, I am facing a strange issue with looker look on my dashboard. I have bar chart and a monthly line chart on top of the bars. I see the total of the last displayed month on the look and dashboard but it does not show up on the .png export! I have tried this several times yesterday and today and I am facing the same issue! Can anyone tell me why or tell me a work around?
Use results from a Look as a Dashboard filter
I have multiple Looks that result in different user ids. Separately I have a dashboard that contains different visualizations for all our users. Is there a way in which I can make all the user ids returned by a Look as a filter to my dashboard so that I can use the same dashboard to analyze different segments of users. Currently, it’s only possible to drill into a particular user id.
Using Table calculations as pivots for period-over-period vizualizations
Hi, I am trying to make period-over-period calculations, which tends to work nicely for absolute periods (I can pivot measures on a timeframe), but as soon as I want to use relative dates this becomes a lot more complicated. A table calculation would seem like the easy solution, since I can create a column defined as ‘years/months/weeks since now’ which yields the correct column for pivoting on. However, I cannot pivot on this column to the best of my knowledge, therefore I cannot use that for a period over period visualization. I’ve seen several blocks built by the community to solve this problem, but given the tools at our disposal seem to almost do the job, I would like to know if anyone managed an easier solution along these lines. Thank you in advance!
Creating a calculated "score" based on multiple dimensions
I’m trying to create a score based on various dimensions. Say my database contains information on different job applicants. I want to create a score for each applicant based on the following criteria (all of this is just an example of the type of thing I’m trying to do so don’t worry too much about the details): –If the dimension Languages Spoken contains “Spanish”, +2. If it contains “French”, +1. else, +0. –If the dimension Years of Experience >5, +5. If between 3 and 4, +3. else, +0. –If the dimension Recommended by HR is equal to “Yes”, +2. else, +0. So for example, someone who speaks French, has 3 years of experience, and is not recommended by HR would have a score of 4. Someone who speaks both Spanish and French, has 1 year of experience, and is recommended by HR would have a score of 5. How would I go about this type of thing? I’m pretty new to Looker and am mostly just looking to be pointed in the right direction in terms of whether what I’m trying to do isn’t possible or wh
Ensure new months pop up dynamically on Bar Chart
I have a stacked bar chart for each month since December '18. When I initially made this chart back in June, I had set my chart to show the months from Dec '18 to June '19. When the data for July started coming in, I wanted the July '19 bar to automatically pop up on the chart next to June’s bar, but it didn’t so I went in and manually changed the settings allowing for July’s data to show. Is there a way I can now ensure that when August begins and August’s data comes in, a bar will pop up for August '19 on this chart? I don’t want to have to manually go in to all my charts at the beginning of every month and change the settings. Thank you!
Automatic filter for 'this month' on dashboard
I have a user-defined dashboard which normally shows data up to the last complete month. I’ve set its default to a fixed date (1970-01-01) and have logic in my views/explores so they filter for the last complete month if the filter has that value, otherwise using the date of the filter so that users can see the data as it was in previous months. I’ve been asked to make this more intuitive, i.e. default to the start of the current month, but I can’t see a way to make a dashboard filter dynamic like this without manually resetting the default every month. I suppose I might be able to create another filter/parameter and do something funky to dynamically generate the options as something like ‘last month’, ‘May 2019’, ‘April 2019’ etc then add more logic to set the original filter based on this but it seems like quite a lot more code to add, when the Explores supporting this dashboard are already quite complicated. Any other ideas?
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.