Dashboards & looks
Building reports & visualizations in Looker
- 1,689 Topics
- 4,117 Replies
Has anyone seen this error before? When I refresh the dashboard it resolves but it seems like a horrible user interface to have to go in to edit mode, clear cache, and refresh for users to not have this issue. Error Stack message:TypeError: Cannot read properties of undefined (reading 'y') at gt (https://static-a.lookercdn.com/22.8.32/webpack/en/src_visualizations_components_Grid_mappers_grid_mapper_ts-4073375b895571e748b4.chunk.js:1:140660) at ht (https://static-a.lookercdn.com/22.8.32/webpack/en/src_visualizations_components_Grid_mappers_grid_mapper_ts-4073375b895571e748b4.chunk.js:1:140374) at dt (https://static-a.lookercdn.com/22.8.32/webpack/en/src_visualizations_components_Grid_mappers_grid_mapper_ts-4073375b895571e748b4.chunk.js:1:139809) at ct (https://static-a.lookercdn.com/22.8.32/webpack/en/src_visualizations_components_Grid_mappers_grid_mapper_ts-4073375b895571e748b4.chunk.js:1:139432) at f_ (https://static-a.lookercdn.com/22.8.32/webpack/en/src_api_api_ts
Hi team, Target - to make a dashboard using 2 different explores. Both the explorers have date fields to group by.(I can't join these 2 data sets in lookml as the granularity is different.)I tried the merge option and I am getting the expected result but I want to use another option (Such as if I can join them at the dashboard level) because I heard about some bugs/errors in merging, from some of my colleagues in their work.Are there any other ways to do this? Thanks!!!
For example, let’s say I have a dashboard with product sales merges three Explores, on the “Product Class” dimension.The dashboard has a “Product Class” filter, and I filter down to “TVs” -- does that filter apply to the individual queries of the three Explores, or does it query all product data for the Explores, and then filter down to the selected class?
Hi, We have a dashboard that we can’t download. When trying to download with the option of “Expand tables to show all rows”, it starts to process it and then we get the error: VisualizationError: Cannot read properties of undefined (reading 'rendered')This happens in the “Preparing your Document” stage
There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a company created each week from the day the company created. I used the ‘date_diff’ function to calculate the week duration between the ‘company_create_date’ to the ‘content_create_date’:The ‘company’ table is also joined to a ‘view’ table that includes all the number of views that a company has in the contents they created, each week from the day the company created. I used the ‘duration’ function to calculate the week duration between the ‘company_create_date’ to the ‘view_ts’: I want to create one table including these 2 tables. When I tried to do that, this is what happened:The week numbers are not synched. Please help me to think of another way to create this table
Hi!I have a filter I need to apply in order to filter Stores, by name, on a dashboard.They all start with the same letters “ZEC”, and they are around 20.So I start typing “ZEC” to select a store. After selecting one, I need to retype “ZEC” to be able to select another store. I have to do this several times in order to get all the 20 stores.I can not scroll through the names as a list, because there are too many, and the ones with letter Z, do not appear!Can anyone provide a tip of another way of doing this?Really appreciate it!
Hi everyone, I am struggling to find a way to set the Default Value of a Dashboard Filter equal to the user attribute.This is the case:I have a dashboard with a filter named “Country”. Each user has a user_attribute called “Country”.What I would like to have is to have a default value for the filter “Country” equal to the contry of the user that is entering the dashboard.Do you know if there is a wat to do it?I tried many things, but there seems not to be a way to do it.Thanks for your help
So I have a cumulative bar graph containing a total number of patients from Jan-March, in a singular bar though. How can I edit it so the bar graph has three bars for Jan, Feb, March. Instead of just one bar that includes all of those 3 months.
Looker email attachment size is still capped to 15 Mb, but numerous email applications allow more than that now. For example, Outlook now allows a max of 35 Mb:Outlook 35 MB cap Are there plans to increase the attachment size eventually? I forget where to check for feature requests.
HiWe have a lot of Looker dashboards created in our company, some of them by the BI team and some by people from other teams. I would like to create a BI creator stamp that will be added to all of the dashboards:it needs to dynamically change by the dashboard creator role- if they have the bi_developer role, a certain image will be created, else, a different image will be presentedAny ideas?
I have a requirement to display multiple dashboards list data, Looks list data with thumbnails. Currently Content API gives one thumbnail per dashboard Id/Look Id. Is there any possibility to get all thumbnails for a given set of dashboard data/Look data.Is there any other way thumbnails can be loaded on embed UI, that is to grab through a content server, to be linked to Image source tag of html.
Hi Community, I just want to express here my frustration on how Looker decides what capabilities to deliver next. We have now the possibility to do Forecasting with ARIMA models but still not out of the box PoP and grouping for others? For PoP we have to follow very complicated approaches and for grouping in “others” not very scalable solutions (table calculations and rankings). I was wondering if we can see the voting for new product ideas
Hi,I have a Look that needs to be downloaded in CSV format to be uploaded to another system. One of the fields has values ranging from 0.01 to 5.00 (up to 2 decimal points).The format that I have for these value is #.##. For example:5.00 0.01 0.20 0.10 etc.The ‘0’ decimal points need to be preserved in the CSV format.However, the ‘0’ decimal points are missing when the Look is downloaded in CSV format.Please advise.RegardsStefan
It is common for our users to click and drag to select a range of data, copy and paste in an email / Slack.We have dashboards with cross-filtering enabled. When the users select a range of data, they are unable to copy. They claim that they have been able to copy before.Any idea if this was a recent change from Looker or a workaround to enable copy on a cross-filtered dashboard ?
i have two date filters on the same dashboard, one payment date and other order date. payment date can be same date or future date from the order date.my base filter is payment date as the dashboard is for payments but i want users to be able to filter their desired order date range as well.for instance:Product Order Date Payment Date Samsung 01-15-2021 06-15-2021 iPhone 01-18-2021 06-10-2021 Samsung 02-10-2021 05-18-2021 LG 04-21-2021 08-10-2021 by default both the date filters are set for YTD, and if i change one filter to a specific date range it just doesnt show data completely because the other date filter is not in the same range. how do i make sure if i select one of the date filter the other either just picks up the same range or at least i can clear the other filter to show all the dates. hope this makes sense
I have a bar chart with potentially long strings on x axis as the dimension. In a bar chart visualization in a dashboard these may be truncated. Is there any way to show the full label, for example on mouse over?I know that the label is shown when I mouse over the values themselves, but not when I hover over the labels.Thanks
Greetings, The title says pretty much everything. We are currently committing to use your platform to save time of development and bring value to our product. The embedded dashboard is a great tool to save cost but it is lacking alot of basic features… like being able to hide only one filter, not all of them.For us, this is the only reason why we would have to switch to Looker API or create custom buttons in our front-end, which would cost us alot of time and efforts that we try to save by using your services. Is it possible to add this feature in the near future (3 months)? Adding a checkbox Hide in the filter options and applying 'display: none' to the html-tag would bring us in heaven. User-attributes are not a good monkey-patch because of the scheduling system. Changing the user-attributes everytime the user has a different selection would corrupt the scheduled reports.Thanks alot and have a great day! Except this important missing feature, the embedded solution is great!
We have a requirement to display images of financial transactions using Looker . The images cannot be stored in a public space due to the sensitivity of the data. Ideally we would want something like this where the user can click on a link to the image, and it open in another window. But the navigation is less important than the security. This is a view of the legacy application and clicking on the image link calls an ASPX page. The ASPX handles the db connection, authentication, image retrieval, and opening it in a new window. We can either store the images in a file store or as data in a database. But it must be secured. Has anyone done an implementation with a similar requirement?Is this possible with with Looker?
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.