Hey Looker Community!
I’ve missed you all in the time since the last 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
Questions and Answers
Running total of distinct values
@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.
Columns stacking together
@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.
Our guest this week is @tnebesar A.K.A Tim Nebesar. Welcome, Tim!
What do you do, and where do you do it?
I’m on an analytics team for a large global retail company. We try to make our data understandable and useful.
How does Looker fit into your day-to-day?
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.
What’s your secret superpower?
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).
If you could open a restaurant, what would its gimmick be?
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.
What’s your favorite word to use to describe data? Mine is “overcooked”.
Clean…it’s too rare.
Community Knowledge Share
Hiding all fields in legend
@nicholaswongsg shared a super efficient way to deselect every label from the chart legend. I actually didn’t know about this shortcut, so thank you Nicholas for sharing your knowledge with the Community— I learned something too!
Simple month-to-date forecasting
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 came back with an awesome reusable LookML pattern to do this.
Powered By Looker Flowchart
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!
Join the Conversation
Don’t forget to post your thoughts about this week’s edition or head over to the Looker Blog for more. 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.