Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

- - Knowledge base
Product Announcements
Events
Groups

Community
Exploring & curating data
Dashboards & looks

Dashboards & looks

Building reports & visualizations in Looker

1,918 Topics
4,348 Replies

When you subscribe we will email you when there is a new topic in this category

1918 Topics

Recently active

Most replies Most views Newest first

Ryanking001

asked in Dashboards & looks

Reference Line Averages - HELP

Hi everyone, I am trying to display an average on a bar chart, using the “mean” function within the reference line. The problem i have is that is counting £0.00 as null and this not displaying the true average. Any help would be appreciated.

3 years ago

Todd_OsborneMember

asked in Dashboards & looks

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 🙂

3 years ago

DawidGood Looker

asked in Dashboards & looks

Reference line label removes value

I would like to have custom label on my reference line but still get the value next to it… At the moment it seems that we can only get one or the other: This makes it difficult to put few reference lines and we need to revert to adding even more table calculations to the mix

3 years ago

irfansNew Member

asked in Dashboards & looks

Threshold breached on consecutive days

I am trying to put together a report that will show locations where a certain KPI was breached on three or more consecutive days in the last 30 days. Does looker support such calculation?

3 years ago

DawidGood Looker

asked in Dashboards & looks

Custom measure based on a different custom measure - missing CASE statement

I have a Custom measure that filters orders by a service, for simplicity it looks something like this: Measure name: special_service Field to measure: orders Filter: ${service.name} = "some service" then I want to further filter this one by a specific product, let’s say like this: Measure name: special_product Field to measure: special_service Filter: ${product.name} = "something" The problem is that my second measure, in SQL, takes orders in its CASE missing the first one… COUNT(DISTINCT CASE WHEN product.name = 'something' THEN orders.id ELSE NULL END) but I expected this: COUNT(DISTINCT CASE WHEN service.name = 'some service' AND product.name = 'something' THEN orders.id ELSE NULL END) or alternatively: COUNT(DISTINCT CASE WHEN service.name = 'some service' THEN CASE WHEN product.name = 'something' THEN orders.id ELSE NULL END ELSE NULL END) Even though I select special_service as my base for calculating custom measure, it’s completely missing the service context…

3 years ago

DawidGood Looker

asked in Dashboards & looks

anthoGood Looker

asked in Dashboards & looks

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

3 years ago

PunitaMember

asked in Dashboards & looks

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?

3 years ago

Gabriella_DiVentura

asked in Dashboards & looks

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).

3 years ago

Dmitry_Yackevich

asked in Dashboards & looks

Base Auth for TV dashboards

We want to show looker dashboards on TV and we need simple way to authentication, the same as for grafana https://grafana.com/docs/http_api/auth/ Our digital signage solution support only Base Auth with custom Authentication header, do you support it?

3 years ago

JakubDMember

asked in Dashboards & looks

[Resolved] Line Visualisation - incorrectly visualised slope

I have this line chart where I display % values across multiple weeks. But the slope of the yellow line between Saturday and Sunday is wrong. Did anyone experience the same thing? Or do you know how to fix this?

3 years ago

Claire_Genoux

asked in Dashboards & looks

Mass (De)Selection in Legend

Hi, I was wondering if the functionality regarding an improvement of the Legend in your viz was in your pipeline? It will be great to have the functions Select ‘All’ and ‘None’ in order to improve the user experience as sometimes, it can be painful, when we’ve a lot of legend, to (de)select each one by one. At the opposite, maybe there’s a tip that we haven’t spotted yet to obtain this? Thanks for your feedback. Claire FYI @Christine_Kelly @alexis_charrier

3 years ago

Prashant_Agrawal

asked in Dashboards & looks

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.

3 years ago

simon_onfidoMember

asked in Dashboards & looks

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?

3 years ago

ayuthika

asked in Dashboards & looks

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!

3 years ago

rory

asked in Dashboards & looks

Downloaded data file contains: Error: Could not sort by calculated field 'total_bla'. Limit reached

Hi, I’m trying to download data for a dashboard and am getting an empty file containing: Error: Could not sort by calculated field ‘total_bla’. Limit reached The docs here: Looker Documentation Using Table Calculations Create new fields by performing calculations on the results of your query. If the number of rows in your query exceed the row limit that you’ve set, you will not be able to sort table calculations. This is because table calculations are only based on the rows that are displayed. Therefore, if you hit a row limit, the table calculation might be missing some rows that it should be sorting into your results. If you run into this issue, you can try increasing your row limit (up to 5,000 rows). suggest to increase the row limit, but even when I increase it to the maximum of 5000, I am still getting the same error. Any help is much appreciated, thanks!

3 years ago

haleybMember

asked in Dashboards & looks

Drill showing too much white space

When I drill into a measure to a bar chart, at certain screen resolutions it shows way too much white space under the chart. I notice this when I’m just using my laptop screen, but on a larger monitor the spacing seems normal. Has anyone else noticed this? I’m using Version 6.8.30

3 years ago

Tovo_RamangasalamaMember

asked in Dashboards & looks

Within "Filters" section allow a "Measure" dropdown/selection list

Note: I may not have typed the right keywords but I didn’t find a topic around what I am about to talk about Basically, I would like the user of a dashboard/look to be able to select from the “filter” section (for example) a list of measures predefined by the developer of the dashboard. (screenshot to illustrate) Like in the filter section, being able to define on which “til” to enable the change. The idea here is to have less tiles which sometimes are just the same layout but with a different measure. Example: Chart1 = Monthly evolution overtime (X axis : mth) of Orders (Y axis) + YoY% comparison (Y axis) Chart2 = Monthly evolution overtime (X axis : mth) of Revenue (Y axis) + YoY% comparison (Y axis) Chart3 = Monthly evolution overtime (X axis : mth) of Revenue (Y axis) + YoY% comparison (Y axis) …

3 years ago

JRyan

asked in Dashboards & looks

Is it possible to display Dimension's values on a chart rather than as an axis?

Hi! I am working on displaying our teams goals + actuals on a chart and am having trouble. I would like to display their goals as one line on a chart and their actual numbers as another line on that chart. Currently, I can only display the Measure (actuals) and can not display their goals as they were uploaded as constant numbers in a Dimension field. I imagine my options are Turn their goals from a Measure to Dimension Somehow visualize the Measure Thank you!

3 years ago

JakubDMember

asked in Dashboards & looks

Copy/Overwrite Dashboards and Looks between spaces

Hi, I’d like to have separate space for Production and Development of Dashboards and Looks. I found out that when I copy the same Dashboard and Look between spaces it doesn’t overwrite existing objects but create new one with appended “(Copy)” to the name. Is there any way to overwrite existing objects and keep original link? Thanks a lot.

3 years ago

simon_onfidoMember

asked in Dashboards & looks

Filter 'equal to' for some dashboard tiles and 'not equal to' for others

I’ve had an interesting question from a user. They (ideally) want to use a single dashboard filter for e.g. a client name, and have some tiles filter to include that client and others to exclude it. I can’t think of a way to do this without doing some funky LookML filters/parameters specifically for this use case - does anyone know a way to achieve this without any LookML changes?

3 years ago

Page 63 / 77

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.