Welcome to “What’s New in Looker?”, a blog post aimed at making you say things like, “Whoa, I had no idea I could do that with Looker!”
This post focuses on new product features of dashboards, Looks, and Explores. We’ll leave the coding to the developers.
I have two great things to share with you today.
Get notified of important changes in your data as soon as they happen with Conditional Alerts. Set the alert conditions yourself or subscribe to an alert someone else made. Either way, you’ll be in the know.
For example, as a customer success manager, you can elect to be notified when your customer’s month-over-month product usage drops by 25%.
If you manage an inventory, you can receive notifications when your average shipping time rises above a certain threshold so that you can investigate what’s causing the holdup.
To set up an alert, hover your cursor over the dashboard tile you want to make the alert for. Click the bell icon in the upper right corner.
Fill out the dialog box that pops up according to your preferences.
In this example, if the “Average Days to Process” value changes to something above 3.4, I’ll get an alert in my inbox every day at 5 a.m. until it falls below 3.4 again.
Click Create Alert to finish.
If you want to subscribe to an alert someone else has created... do it! Tiles with existing alerts display a number over the bell icon. Click it to open the alert pop-up.
Click Follow on the window that appears next. You’ll get on the recipient list like a nice fall breeze goes through an open front door... effortlessly.
Which data changes are most important to you and your team? Think over your favorite dashboards and consider creating an alert using this new Looker product feature today.
Apply conditional formatting to a single value visualization, and you’ll know how your metric is performing at a glance.
In the example below, the number will display in red if the customer health score is below 50. If it’s above 70 (that is, worthy of a celebration dance), the metric will display in green.
To apply conditional formatting to a single value visualization, edit the tile.
Select the Formatting tab and click the Enable Conditional Formatting toggle.
Set your rules. In this example, if the number of open orders is more than 1000, the value will appear in orange.
And that’s it!
If you want to get creative, you can even use conditional alerts and conditional formatting in tandem. You can set up the value to go through a series of color changes, and send an alert when it hits the final color threshold.
It will be like a pressure gauge on a hot water heater with a warning alarm — except for your data!
Have any feedback or questions? Get in touch via the Community discussion on Exploring.
Until next time,
Content Strategist, Customer Experience