Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
I work with a lot of dirty user entered data. I would like to try to bucket all of my results into a cleaner report. Something like: Report all records where vendor_name contains ‘Agilent’ as ‘Agilent Technologies’. I can ask for all of the iterations, but I’m having trouble bucketing all of the results into an " as " statement. Is there way to build a customer filter or alter my report?
Can we normalize the y-axis between two line charts so it is easier to compare?Details: Currently, the charts have dynamic y-axes. This means that each chart will end up with a different scale on its y-axis. We want to make them align so that people can visually compare the data using the chart heights.
I have a few merged Explores/Looks that I am hoping to save onto multiple Dashboards but it seems like this is not a feature currently in Looker. Has anyone come across this issue before and have a solution? I’d ideally like to limit the duplicate merged Looks I have to create so I don’t have to update them all one by one. Thanks!
I’m using the advanced date filter to select absolute number of days from a specific date. In the documentation, it says the following: 2018/05/10 for 3 days from 2018/05/10 00:00:00 through 2018/05/12 23:59:59 However in my results, the prior day is appearing: Anyone aware of a bug or if there’s a particular reason for this?
Consider, a view has been built and has been scheduled for a one time refresh everyday at 6 am. Also, consider a look A1 (10 Dimensions and 10 Measures) is built on this view and a look A2 (2 Dimensions and a Measure - Kind of aggregated look on A1) is built on A1. When I edit and run the look A2 later for example at 10 am, the looker fetches data from the cached View or from A1.
Hi all, Our team created a Looker dashboard and embedded it in our company website by using i-frame. My question here is how can I grant the access to certain users (basically anyone in my company can view)? Previously we had a tableau dashboard and it allow us to create tableau token while embedding in the web page. User only need to sign-in their company’s email to view the dashboard. Hope anyone with similar experience can answer this question. Thanks
Hi!I’m building a custom visualization and I’m wondering why it takes so long for the tile view to show up if the content of the graph was downloaded into the DOM pretty quickly? Is this a Looker issue -- there’s nearly a minute of loading time and I’m not sure what for...?
By default the labels are vertically centered. But when I change the Percent Type to the previous rowSuddenly they go to the top:Reason? The label <p> element gets correct CSS: but after changing to previous row The top property and translateY is reduced to 0
For example, the total revenue in a given month is $1,000,000 When I pivot by a dimension like product categories (X, Y, Z), the revenue for each category will be:X = $400,000 Y = $150,000 Z = $400,000 Row total (looker) = $1,000,00 Row Total Manual Sum = $950,000What is a potential cause for this discrepancy?
Hi,We have recently started using the Enhanced Navigation and pinning dashboards to Boards to improve navigation, however the load time of both the Boards and the Enhanced Navigation Links (pic below) in the boards is extremely slow.A Board with 79 dashboard links over 14 sections takes between 45 and 60 seconds to load which seems excessive. Another with 8 dashboards over 4 sections typically takes 15 seconds to load. I would like to use boards as the primary method of navigation for my customers as I can integrate it with access control and get a high degree of control over content, but I can’t have these long load times.Does anyone know of any way I can speed up the load times?
Hi All, Hope you are doing well and staying safe. So Basically i got a dashboard that have “Daily Admins Performance” filtered by name so it’s easy to schedule, something basic. what i would like to know is, if we have 12 admins could we somehow cascade the visualizations of them in 1 email. to avoid spamming. P.S: Scheduling them under the same name might be a solution to this but i’m just check if there a more neat way to do it, where they will seems more as if there were 1 dashboard. Best Regards,
I have a pivot table with main dimension and dates.I'm trying to find a way how to highlight smallest/biggest values for dimension over periods.On screenshot you can see an example.What should be in this case for ROW, on week '’2022-11-28" value should be in fully red, on week '’2022-11-07'’ fully green.Right now Looker highlights smallest/biggest values based on Column, not on RowAppreciate any ideas how to do this.
Hi all, Has anyone had any success with parsing Active Directory data (such as group policy, or domain controller data), Okta events (such as application add/delete), or Azure PIM events in Looker? Or other data/security log events? Can you educate me on your processes? We’re looking at trying to look at some of this data internally, potentially for future audit processes and wonder what others have done. Thanks, in advance.
In our most common dashboards, we want different users to see different visualizations. In order to do this now (based on the feature set from 3.8), we use external tooling: a script which identifies which combinations of charts make up legitimate dashboards, and then generates the filtered dashboards. We would prefer to actually just filter them from a comprehensive dashboard. Is there anything in the more recent versions that support this?
Hello everyone, I am fairly new to Looker and I have been tasked with coming up with a way to group employees by the length of time they have worked for our orginization.Basically I need to make two categories that will allow me to filter agent by tenured and non-tenured based off hire date.0 to 3 months=Non tenured 3+ months= TenuredTo do this I need to figure out a way to extract the time worked from the agent hire date till now (today's date) and then categorize the result in months into the two field described above. Based off the data I have I will need to do this via a custom filter but I am having trouble stringing together the formula to extract and catigorize.Any help you could provide would be appreciated.Thanks,Jeramy
I need to create report based on this data. I need to get the used size on a day based on the maximum time stamp for that day.Also get the daily average rate of increase on used size. How can i frame the query and built report in Looker.I tried using sub string function to split the time stamp but did not work as i have group by based on date field. Max size Used Size Size available Time Stamp 1.4 P 815.0 T 574.8 T 2017-03-09 17:30:37 1.4 P 815.0 T 574.8 T 2017-03-09 17:30:37 1.4 P 818.0 T 571.8 T 2017-03-14 16:00:39 1.4 P 818.0 T 571.8 T 2017-03-14 16:00:39 1.4 P 817.2 T 572.7 T 2017-03-14 16:20:32 1.4 P 817.2 T 572.7 T 2017-03-14 16:20:32 1.4 P 815.0 T 574.9 T 2017-03-14 17:40:34 1.4 P 920.9 T 468.9 T 2017-03-15 01:10:35 1.4 P 817.0 T 572.8 T 2017-03-15 05:10:29 1.4 P 817.0 T 572.8 T 2017-03-15 05:10:29 1.4 P 813.7 T 576.1 T 2017-03-16 11:30:32 1.4 P 816.8 T 573
I’m not sure the best place to put this, and know this is a long-shot to ask Looker for, since even the customer service orgs haven’t developed it … Does anyone have a good way of handling forecasting support tickets and allocating a schedule for staffing? We’re currently hacking this in Excel and then pushing the output into Redshift. I’m sure, we could also hack it in Looker, so wanted to check to see what others are doing. 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.