Getting Started in the Looker Community
- 212 Topics
- 337 Replies
How to merge colum on looker langage (RMS tools)
Good evening everybody,I am working with hospitality industry using a RMS (Revenue Management System) tools called PACE.PACE is using looker langage.I am quite not still familiar with it and I am here because I don’t manage to merge column in a graph.To sum up, please let me display the data that I currently have on my screen : Could someone help me to display “Left to sell” and “Local ADR” on the same colum (on a daily basis?)I hope having shared this topic to the right place, I can otherwise move to the right one. Please let me know. I can see that there is 2 classes in the “Developpement section” > LookML and SQLI am not even sure I am able to code under that tool.Thank you for your kind assistance.Quentin
Designing the perfect model
What is the best approach when you have billions of rows in one table, should I make a star schema and make aggregation views on those fact table and dimensions and after that connect looker to those aggregations or should I connect looker to the one big table with all columns?
How to Combine Two Tables With No Shared Dimensions?
Hi all, Hopefully the infographic I made should explain what I want to do at-a-glance. But to explain, I have multiple data sources in Looker for marketing data that I want to combine. I’m stumped because there are no shared dimensions, and I need to combine the tables by metrics rather than dimenions. One source is Google Ads, which has multiple campaigns with different names. Here we track mentions called “clicks” and “impressions,” plus others. Another source sis called Facebook Ads, which also has multiple campaigns called “clicks” and “impressions,” among others, as well. I would like like to combine these in one table. In Excel, this would be done with a simple copy-paste. I’m unsure how to do it in Looker. Can anyone help?
Combining data from multiple tables in a new table
Hi all,I’m having to use a filter on Conversion Type Name to separate some offline conversions vs general conversions within All Conv. You can only filter the entire data set at once as opposed to the specific metric - if I could do that, I could add All Conv. twice and filter then differently. So now I have two pages, two tables, all KPIs are the same (imp, clicks, CTR etc) except for the conversion. I’d like to combined the tables so I have both types of conversion in the same table, each in it’s own column then create further conversion KPIs. Is this possible in Looker? Easy in sheets I know but trying to avoid using that for now. Thanks
SEO multilingual dashboard
Hello. I am new to this but basically I want to build a dashboard on looker to keep track of my SEO impressions, users, (etc.) by languages. My website is built like thisxxx.com/ => FR urlsxxx.com/en => EN urls (the hompage is .com/en and the other pages are .com/en/...)I would like to know what kind of filters or whatever should I use to create separate dashboards based on the URL structure (.com/ and .com/en), using different types of data (GSC, Analytics). I am sure there are formulas available however I can’t find them. Thanks.
cross filter management (date range comparisons)
I have a bar chart with monthly totals (pageviews) and am using a cross filter to show monthly details of other metrics when selected. I have a table including running calculations for each month (month over month percentage changes for each metric). When the month is selected, I want only that month to appear in the table but the table calculations not to change. For example, when July is selected I want to the table to display the percentage changes compared to the previous month (june) instead of compared to itself (as that is the only data not filtered out).
📺 New Looker-Focused Webinar Series!
📺 New Looker-Focused Webinar Series Hi everyone! The team at Spectacles is excited to announce our new Looker-focused webinar series. Every two weeks we’ll be getting together to do a deep dive into some area of Looker and analytics. They will be scheduled for Wednesdays at 12pm ET. Each session will be recorded so you can also watch it in your own time if you can’t make the session. The idea for the sessions is to regularly get the Looker community together in the same place and talk about actual hands-on experience with Looker. If you have something that you would be interested in presenting, we would love to hear from you! 🙏 Our first session will be on November 30th. We’ll be talking about How To Fix Your LookML Project Structure, including how to use refinements to keep your code DRY and manageable. You can register for the webinar here 👈. We’ve got the next five webinars already scheduled. You can always see all upcoming webinars on this page. The topics include:Managing Mult
What should the structure of your productized analytics solution be?
Did you know that companies with analytics capabilities are twice as likely as those without them to rank in the top quarter of their industries' financial performance? I'd venture to say that you want to see your clients prosper. A data offering might make sense given that analytics might aid in their success.But where do I begin? It takes a lot of work to figure out how to productize your data. Tripp Shroom are also selling cannabis products like penis envy spores. Here we prefer our customer to take it easy.
Hi,We use google sheets as a way to load data data into Google Looker Studio to visualize information based on us zip codes. We have something like 40k rows of zip code data.When we tried to vizualize this the UI only shows a few states of data. Is there a way to visualize this data fully? Are there limitations on Map Viz data?Thank you
Uncertain on Best Practices for Aggregations
Hi all,I’m new to Looker and come from a background of mostly using Tableau where my team used to create a ton of aggregation tables and link those to Tableau to display on a dashboard for stakeholders. What I’m trying to understand with Looker is if it’s efficient to continue with this practice of creating aggregate tables on my db for pretty much any view we’d like to report on and then having Looker pick it up OR because of LookerML is it more efficient to bring in the raw tables and create the aggregate views on 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.