Dashboards & looks
Building reports & visualizations in Looker
- 1,922 Topics
- 4,344 Replies
Cumulative Count for every day in a month
I am trying to build a Look that counts all the distinct ids that appear in a table, and I would like to do a cumulative count for each day in a month. The ids follow a non-linear distribution, so I can’t take the total for the month and divide by the number of days. And since it’s distinct id’s I can’t just do daily counts and use a calculation to do a cumulative count column. Does anyone have a suggestion for how I achieve this in Looker?
Reporting on last Sunday and Sunday before
We have a table that provides the daily snapshot of active premium accounts, and I am trying to provide a look that compares the previous Sunday’s info (October 10th) to the Sunday before’s (October 3rd). Is there any magical way to specify these dates maybe via a custom filter?
Getting last value for a measure over a time period
I’m building out a LookML dashboard with a date filter where I need to sum certain fields (such as revenue) but also provide an end-of-the-period count of customers. start_of_period = 2016-09-01 end_of_period = 2016-09-30 revenue = “select sum(revenue) from orders where order_date between start_of_period and end_of_period” customers = “select count(customers) from orders where order_date =end_of_period” The revenue piece is easy using a filter like this: filters: - name: date title: “Date” type: date_filter default_value: yesterday Any suggestion on how to return a measure based on the last date of the range? Thanks
How To Format Multiple Non Combined Y Axes' Values
I looked in the Excel documentation as well as other Looker resources and didn’t find anything on how to format Y Axes values in visualizations with multiple series that are not combined. I tried “#,##0 | #%” for example, and a comma delimiter won’t work since that’s included in some of the formats. Is there a different delimiter to use between Excel style formats to make this work?
Adding drop down arrow for field filters
When a user places their cursor in a field filter in a dashboard, a loading dotted line (similar to a loading bar, but it’s a line) appears under the input box and eventually a drop down of values appears. Most of our users do not know that they are going to get a list of options with that filter. I was wondering if we could add a drop down arrow to the right of field filters so users know they can select from a list of options.
Data Dictionary Best Practices
I’m not sure if this is the right category for my question, but the description has ‘best practices’ in it, so here goes. Where do you store your data dictionary, and has it worked? Looker pitched their recently-released LookML Model API endpoint as being a tool to enable building a data dictionary. I’m inferring then that at least some users store the dictionary outside of Looker. As of last year, Warby Parker used gitbook. But Looker has come a long way with annotations and the markdown homepage, and in theory, the dictionary could live within Looker itself. Here at Managed by Q, we briefly tried using a google spreadsheet, but now matter how many times and places we linked to it, no one ever used it. I’d love to hear input from the Looker community on how they’ve approached this problem.
Editing Dashboards Bug
Hi, I am using the table visualization with some dashboards. I had to go through and pull the bottom of the table to the bottom so there was no scroll bar and it could be printed on one page. I noticed that if I do it outside of dev mode and then export to pdf the changes do not flow through. It seems like I have to do it both in and out of dev mode for the changes to flow through. It isn’t because I am trying to export right away either, some of these dashboards I had updated a week or two ago and just now noticed they weren’t showing up properly in the pdf. Is there a reason we have to update the dashboard in both dev and out of dev mode for the changes to show up in the pdf file?
Reducing Size In PDFs
Anyone have any hacks to reduce the size of PDFs from downloaded dashboards? I am using a table visualization and most of my PDFs are coming out to 1.5MB - 2MB each. I am then combining multiple of these into a deck. So it quickly adds up to 30+MB. I have tried optimizing/shrinking using Adobe PDF and Nitro PDF but it doesn’t shrink it very much. Anyone else have any luck with anything else?
Comparing Calcs from different Looks/Dashboards
Hello, I was wondering if there is the ability (or will there be the ability) to pull a calc from another look. For example, we have a dashboard for our 2015 numbers and I would love to be able to pull those numbers from those looks to the 2016 dashboard for comparison on a look. So “2015 | Execs Met” the number from their can be pulled to a look called “2016 | Execs Met”. Not sure if this is possible, but would be great if it was! Thanks, Parijat
Dual axes needed for visualization with two measures and pivot
I am using Looker 3.46. I am trying to create a visualization with 2 axes, one for transaction count the other for transaction response time, both charted over time. The data includes a pivot on transaction type which I would like to display as multiple series. However, I am not able to turn off the Combine Axes feature. An informational message is displayed, " Must combine axes when using both pivots and multiple measures" when I examine that setting. As you can imagine, the scales for transaction count and transaction response time are vastly different and make no sense when combined. Is there another way to achieve what I am trying to do or can an enhancement be made to allow multiple axes when there are 2 measures?
Bug with display of euro sign in dashboard graphs
Hi, When i have a table calculation with the below formatting it is displayed correctly in the visualisation. However when de visualisation is added to a dashboard it is not presented correctly. When i remove the euro sign it works ok. [>=1000000]€0.0,“M”;[>=1000]€0.0,“K”;[<-1000]€0.0,“K”;€0.00
Dynamically set default dashboard filter value?
Hi, What’s the best way to set default, initial value for a dashboard filter in embedded mode? Regular dashboard filter seem to allow setting static values only. I am wondering if there’s a way that embedded dashboard can pre-populate initial filter values with something that’s either received as URL parameter or looked up dynamically from the database. For example, each SSO user may want to open dashboard with his own preferred currency . Thanks, Matt
Dashboard HideFIlters From PDF
I see the option if you create a dashboard using LookML. But I don’t see how to edit LookML for a dashboard created using the UI or the option to exclude filter. I want to basically do this with a dashboard created using the UI; is that possible?: https://looker.com/docs/reference/dashboard-reference#show_applied_filters
Using hidden field as a filter
Hi, I am trying to link two dashboards on Looker and what I want is that when I switch from one dashboard to the other by clicking on a field I should be able to filter the dashboard on a hidden field. On this link it says: Hidden fields can still be accessed in the UI if they are manually added to the URL, and will show up in some Looker windows. Therefore, think of hidden as a way to keep the field picker clean, and not a security feature. If so, can I use my hidden field (say id) as a filter on my second dashboard?
[Feature Request] Hover-Over Descriptions in Visualizations
This hover-feature is great when building an explore, but would be even more valuable when sharing information via dashboard or other viz with coworkers who have far less experience with Looker and our ever-changing analytics. This would be useful in all types of visualizations.
Dashboard Export To PDF Error
I have a dashboard that has a table visualization. It shows up fine on the web intereface but when I download it to PDF the right side is cut off. The graphics above it still show up inline on the page but for some reason the table goes off the edge of the PDF. Any suggestions or is this a bug that needs to be fixed?
Scheduling a Look - if results do not change
I like the feature where one can schedule a Look if there are results, and if results changed. Wondering if it’s possible to include a feature where Looker sends out email if there are results and results haven’t changed since last delivery. Context being that if a table (in Google BigQuery) is not being updated regularly, this feature would notify us that data is not being uploaded as it should. Or if anyone has any hacks to get around this, that would be great! 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.