Hey Looker Community!
I’ve missed you all in the time since the Podium. I was so glad to see smiling faces from the Community in person at JOIN: The Tour, Los Angeles. There’s something particularly great about putting faces to usernames, and I look forward to meeting more of you at future events to come.
Speaking of events to come, tomorrow — Thursday, March 21st — Looker is hosting an Office Hours event focused on ‘Building Impactful Dashboards’ in both our New York and San Francisco offices. From 3:30pm-5:00pm local time, there will be presentations, snacks, and great company and conversation. Learn more and sign up here, and if you go to the San Francisco event, I’ll see you there!
With that, let’s dig in and see what’s new in the Community with this week’s edition of The Podium.
Community Manager, Looker
AndrewDoesData was working to create a running total of distinct values, using table calculations. Our beloved Fabio, also known as LookerIO, jumped in to provide a table calc method for him, as well as a derived table approach.
Looker Community Discussion - Running Total of Distinct Values
Paul_Wadsworth was having some trouble getting a waterfall chart to display correctly. Bens jumped in and provided some wisdom that illuminated the pathway to the solution.
Looker Community Discussion - Columns Stacking Together in Chart
Our guest this week is @tnebesar. Welcome, Tim!
I’m on an analytics team for a large global retail company. We try to make our data understandable and useful.
I’ve been using Looker a lot recently. We have a lot of people very eager to get into the weeds of our data who don’t necessarily have the technical skills to query it themselves. Looker is great for democratizing and standardizing data. The more that we can build and socialize in Looker, the fewer questions and requests for ad hoc queries/analyses we get so it’s a win/win.
Hmm I don’t think I have a superpower — more of a jack of all trades. I do make a nice leather sunglasses strap among other hand-crafted goods though when not wrangling data. Check out timsxtim.etsy.com and use LOOKER15 for 15% off (shameless plug).
I’ve actually had this idea for a while. My go-to breakfast is scrambled eggs mixed with basically whatever I have in my fridge, eg cheese, peppers, onions, sausage, fresh salsa and sour cream. I’d call my restaurant “Dirty Eggs,” and it would be a fast casual restaurant where people can choose different ingredients to add to their scrambled eggs (no omelettes allowed). I have no interest in owning a restaurant though so someone else should do this.
Clean…it’s too rare.
nicholaswongsg shared a super efficient way to deselect every label from the chart legend. I actually didn’t know about this shortcut, so thanks Nicholas for sharing your knowledge with the Community — I learned something too!
Looker Community Discussion - Hiding All Fields in Legend
Looker’s own Marcus_O_Hanlon came up with an elegant table calculation to forecast a KPI on a month-to-date basis. After nmorrison’s initial refinement to calculate year-over-year, Marcus_O_Hanlon came back with an awesome reusable LookML pattern to do this.
Looker Community Discussion - Simple month-to-date Forecasting
I’ll let fabio’s words speak for themselves:
“With the huge amount of flexibility offered by Looker in terms of serving analytics to your customers, it can often be daunting finding the right documentation that applies to your situation! That’s why I’ve put together this flowchart to guide you.” This is awesome stuff, Fabio!
Looker Community Discussion - Flowchart for configuring Looker to your PBL tenancy situation
Head on over to Discourse to join the conversation and post your thoughts about this week’s edition. Share some kudos with Tim and ask him more about sunglass straps, eggs, or clean data. Also, be sure to share your comments to grow about any specific discussions and tips that have helped you out lately. And of course, be sure send in your questions for the next Spotlight feature.